I wish to know the best way for others (who wont have a "Developer" tab in Word) to to show a userform.



So far I have a userform that opens when a document opens. After closing this userform I can re-open it though a commandbutton. But this commandbutton prints when the document prints. I have found some vba code that can print the document without the commandbutton showing but this means printing via vba which I don't want to do (to make it easier for others).



Thanks Sandy

Easiest way is to put a button in the QAT. Instructions are here https://answers.microsoft.com/en-us/...d-0b058a0ef3e7

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thanks Andrew. Will the new button in the QAT be available to others on their own computer?

Yes it will IF you pay attention to where the customisation is stored.

The second point of Pam's answer was "-On the right side of the screen under Customize the Quick Access Toolbar, choose For [YourFileName.dotm]."

This is very important. This ensures the button is part of the template where your macro is stored. If you put the button customisation into 'for all documents', then the button is saved in your Normal.dotm template which is not (or at least shouldn't be) distributed to the other users.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Somewhat less simple, but rather more elegant, is to add the button to the ribbon of your template http://gregmaxey.mvps.org/word_tip_p...bbon_main.html

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks Andrew that worked a treat. Cheers Sandy

Thanks Graham, will read your article and try it later on. Cheers Sandy

Can you tell me how to mark this thread as solved?