Assigning Macro name puts the workbookname in front.

[swade730]

Hi,

I want to assign a Macro name to a button. but the issue is in the Assign Macro name window...the Name of the workbook preceeds the name of the actual Macro. When I try to remove the workbook name, and save it and then go in to try to re-assign the macro to the button...

I see the name has not changed and the workbookname still stays in front of the macro name?

Any clue as to what causes this?

[Parth007]

Macros are stored in modules. One module can contain lots of macros. You can use this to organize your macros: put a group of functionally related macros in one module, and another group in a second module.
For example, you could have a module Maths with macros that perform mathematical calculations, and a module Finance with macros that perform financial calculations. Use whatever is convenient to you.
You don't have to export the modules to name them; you can give modules meaningful names within the Visual Basic Editor itself:
•Select a module in the Project Explorer
•Change the name in the (Name) property in the Properties pane (press F4 if you don't see it).
But! You should not give a module the same name as a macro - that is confusing to VBA, and - as you have found - it forces the Macros dialog to prefix the macro name with the name of the workbook and of the module

Also you can store the macros in an Add-in.
The macros will not be prefaced with a workbook name in that case.
But the macros will not show up in View Macros............you just assign them to a button or shortcut key.

Do refer below link.. may be of help

http://www.excelbanter.com/showthread.php?t=382144

[swade730]

Thank You Parth!