Activating a userform

Guessed · #1 03-26-2017, 07:13 PM

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.

gmayor · #2 03-26-2017, 09:15 PM

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

gsandy · #3 03-27-2017, 10:50 AM

Quote:

Originally Posted by gmayor

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

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

gsandy · #4 03-27-2017, 10:55 AM

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

gsandy · #5 03-27-2017, 10:49 AM

Quote:

Originally Posted by Guessed

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.

Thanks Andrew that worked a treat. Cheers Sandy

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