Accessing the "Printed Watermark" dialog in XP/2003

T

Trevor Henderson

Hello All
Is it at all possible to do a .Show directly to the watermark dialog you get
to via the menu system clicks of Format -> Background -> Printed Watermark.
We use this watermark dialog a lot and would like to bypass all the menu
clicks.
Here's hoping
Trevor Henderson
 
J

Jonathan West

Trevor Henderson said:
Hello All
Is it at all possible to do a .Show directly to the watermark dialog you
get
to via the menu system clicks of Format -> Background -> Printed
Watermark.
We use this watermark dialog a lot and would like to bypass all the menu
clicks.

Hi Trevor,

Go to Tools Customize. With the Customize dialog open, go to Format,
Background, Printed Watermark, Hold down the Ctrl key and then click the
item & drag it to any toolbar you want it to be available on.

Now that you are aware that it is possible to customize toolbars, you might
be interested in this article.

Creating Custom Toolbars for Templates
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=262
 
J

Jay Freedman

Trevor said:
Hello All
Is it at all possible to do a .Show directly to the watermark dialog
you get to via the menu system clicks of Format -> Background ->
Printed Watermark. We use this watermark dialog a lot and would like
to bypass all the menu clicks.
Here's hoping
Trevor Henderson

Hi Trevor,

Since Microsoft hasn't seen fit to add that dialog to the Dialogs collection
that's accessible from VBA, the best you can do is a SendKeys that simulates
entering the menu selection keystrokes:

Sub DialogWatermark()
SendKeys "%okw"
End Sub

Assign a keyboard shortcut or toolbar button to the macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top