Prev: Delete Inline Shape Problem
Next: Convert to PDF
From: Doug Robbins - Word MVP on 29 Oct 2009 05:07
I would do it with a userform.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Vinnie" <Vinnie(a)discussions.microsoft.com> wrote in message
news:8A4A776C-E6A6-46A9-8718-F8BFAF5438D0(a)microsoft.com...
> Hello Doug,
>
> Let me rephrase my question a bit clearer :)
>
> The dropdownboxes are not meant to be on a form, they are there to let the
> user select predefined text that is stored on a sql database.
>
> when the user selects an item in a dropdownbox, it is automatically filled
> in (also by script of course) in a bookmark under the dropdown.
>
> Now what i would like is to be able to hide the dropdowns:
> - when the document is printed (or make sure that they do not appear on
> the
> printout).
>
> Is this possible (with having to create a form)?
>
> Thanks,
>

From: Vinnie on 29 Oct 2009 05:56
So no possible way to hide dropdowns, in the document and without userform,
when the document is printed ?

:( this would mean i have to redo my document (and since i'm a bit of a
newbee ...)

but thanks anyway for the answer.
From: Doug Robbins - Word MVP on 29 Oct 2009 20:30
You could select the combobox and assign a bookmark cmbbox to it and then
use the following code

ActiveDocument.Bookmarks("cmbbox").Range.Font.Hidden = True
Options.PrintHiddenText = False


--
Hope this helps

Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to avail yourself of my
services on a paid, professional basis.

"Vinnie" <Vinnie(a)discussions.microsoft.com> wrote in message
news:28E2ADF4-2559-4B4B-8BDF-2CF9BA252BC0(a)microsoft.com...
> So no possible way to hide dropdowns, in the document and without
> userform,
> when the document is printed ?
>
> :( this would mean i have to redo my document (and since i'm a bit of a
> newbee ...)
>
> but thanks anyway for the answer.


From: Vinnie on 30 Oct 2009 07:57
Just one last question.
How do I "assign" a bookmark to a combobox ?

Thanks in advance.

"Doug Robbins - Word MVP" wrote:

> You could select the combobox and assign a bookmark cmbbox to it and then
> use the following code
>
> ActiveDocument.Bookmarks("cmbbox").Range.Font.Hidden = True
> Options.PrintHiddenText = False
>
>
> --
> Hope this helps
>
> Doug Robbins - Word MVP
> Please reply only to the newsgroups unless you wish to avail yourself of my
> services on a paid, professional basis.
>
> "Vinnie" <Vinnie(a)discussions.microsoft.com> wrote in message
> news:28E2ADF4-2559-4B4B-8BDF-2CF9BA252BC0(a)microsoft.com...
> > So no possible way to hide dropdowns, in the document and without
> > userform,
> > when the document is printed ?
> >
> > :( this would mean i have to redo my document (and since i'm a bit of a
> > newbee ...)
> >
> > but thanks anyway for the answer.
>
>
> .
>
From: Vinnie on 30 Oct 2009 08:27
ok, this is what i tried already.
i insert a combobox, i seldect it and then i insert a bookmark.

As far as i can see, the combobox is IN the bookmarkt.

I have then created 2 buttons:
1) show bookmarkt
2) hide bookmark
for test i put a msgbox with the buttons, so i can see that they are called.

Both buttons work and i have put the code to hide the bookmark :
ActiveDocument.Bookmarks("cmbbox").Range.Font.Hidden = True
Options.PrintHiddenText = False

I have also checked the print options before printing and the checkbox with
hidden text is unchecked.
But in the printpreview the checkbox is still visible.

Is this normal?

Greetings,


"Doug Robbins - Word MVP" wrote:

> You could select the combobox and assign a bookmark cmbbox to it and then
> use the following code
>
> ActiveDocument.Bookmarks("cmbbox").Range.Font.Hidden = True
> Options.PrintHiddenText = False
>
>
> --
> Hope this helps
>
> Doug Robbins - Word MVP
> Please reply only to the newsgroups unless you wish to avail yourself of my
> services on a paid, professional basis.
>
> "Vinnie" <Vinnie(a)discussions.microsoft.com> wrote in message
> news:28E2ADF4-2559-4B4B-8BDF-2CF9BA252BC0(a)microsoft.com...
> > So no possible way to hide dropdowns, in the document and without
> > userform,
> > when the document is printed ?
> >
> > :( this would mean i have to redo my document (and since i'm a bit of a
> > newbee ...)
> >
> > but thanks anyway for the answer.
>
>
> .
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Delete Inline Shape Problem
Next: Convert to PDF