LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Reassigning macro to add in function

I have a button assigned to a macro that I moved to an add on. To reassign
it in the macro name dropdown I type 'My vba code.xla'!MyFunctionName.
But when I click on the button it says Macro MyFunctionName not found.
When I go back into to edit the macro name it has stripped away the xla
reference and just left the macro name which suggests it has found it.
Anyone know what the problem might be?

Regards, Tom.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sub Macro vrs Function Macro Auto Start Pat Excel Discussion (Misc queries) 7 June 6th 07 09:53 PM
Alternate printg 2 Wsheets to diff printers w/out reassigning ptr Robert L Excel Discussion (Misc queries) 1 September 30th 06 02:34 AM
Reassigning macro locations for toolbar buttons dm59 Excel Discussion (Misc queries) 3 January 12th 06 05:58 PM
How can I stop my Excel hyperlinks from reassigning their destina. Jim Gobrecht Excel Discussion (Misc queries) 0 October 25th 05 10:33 PM
reassigning keyboard shortcuts Dracorat Setting up and Configuration of Excel 1 October 8th 05 11:47 PM


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"