Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changed module names don't register in toolbar links
I renamed my modules from Module1, Module2, etc., to more meaningful,
recognizable modules. Problem is, when I press the toolbar button assigned to a macro, I get an error message that it can't find the macro. I need to go to Customize and redefine each macro assignment to reflect the new module names. Why can't Excel do this automatically, much as it does when you move a cell and it updates all formulas to the new location? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changed module names don't register in toolbar links
You will have to ask the designers of the software. They don't answer
questions here. -- Regards, Tom Ogilvy "hmm" wrote: I renamed my modules from Module1, Module2, etc., to more meaningful, recognizable modules. Problem is, when I press the toolbar button assigned to a macro, I get an error message that it can't find the macro. I need to go to Customize and redefine each macro assignment to reflect the new module names. Why can't Excel do this automatically, much as it does when you move a cell and it updates all formulas to the new location? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changed module names don't register in toolbar links
I believe the OnAction property of the toolbar button is a string, which
means that it will not auto-update. The better course of action is to always use a macro to create the toolbar buttons when your library file or add-in file is opened, and remove them when it is closed. HTH, Bernie MS Excel MVP "hmm" wrote in message ... I renamed my modules from Module1, Module2, etc., to more meaningful, recognizable modules. Problem is, when I press the toolbar button assigned to a macro, I get an error message that it can't find the macro. I need to go to Customize and redefine each macro assignment to reflect the new module names. Why can't Excel do this automatically, much as it does when you move a cell and it updates all formulas to the new location? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar has changed - how to return to normal | Excel Discussion (Misc queries) | |||
protect custom toolbar from being changed ? | Excel Discussion (Misc queries) | |||
Specific location to register the worksheet names of a workbook | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
Changed Links | Links and Linking in Excel |