#1
|
|||
|
|||
Activating a userform
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thanks Andrew. Will the new button in the QAT be available to others on their own computer?
|
#4
|
||||
|
||||
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 |
#5
|
||||
|
||||
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 |
#6
|
|||
|
|||
Quote:
|
#7
|
|||
|
|||
Quote:
|
#8
|
|||
|
|||
Can you tell me how to mark this thread as solved?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Userform calls other userform, then populate worksheet | Lehoi | Excel Programming | 0 | 02-03-2016 02:58 PM |
VBA Code in a UserForm module to delete a Command Button which opens the userform | Simoninparis | Word VBA | 2 | 09-21-2014 03:50 AM |
Unhiding a workbook and activating it in VBA | Gratje | Excel Programming | 4 | 11-07-2012 05:19 AM |
Activating or decativating Cell | ubns | Excel | 6 | 04-30-2012 10:05 PM |
help activating office | JamiEngland | Office | 1 | 01-26-2012 09:47 PM |