![]() |
#1
|
|||
|
|||
![]()
I have created a template called "Sandra Macros.dotm"
I have created a custom menu to call a procedure in this template Set myCmdBarCtl = myCommandBar.Controls.Add(msoControlButton) with myCmdBarCtl .BeginGroup = True .OnAction = "=SaveAllImages()" End with I attach the template to the current document If I move the procedure SaveAllImages() to Normal.dotm the button works. If not I receive an error " The macro cannot be found or has been disabled because of macro security setting" - The macro security is low ... it works when in Normal.dotm. How should I indicate to "OnAction" to search in the template? tried adding the template name .. did not work |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rocky2 | Word VBA | 1 | 04-04-2016 12:00 AM |
#REF Error when calling VBA Function | RodneyJ | Excel Programming | 1 | 01-21-2016 12:42 PM |
![]() |
SeattleITguy | PowerPoint | 4 | 11-26-2014 01:41 AM |
![]() |
donbexcel | Word VBA | 1 | 11-02-2011 05:25 AM |
Re-Calling Sent Email | freschij | Outlook | 1 | 12-06-2010 09:16 PM |