Should be able to change name for a macro

M

mrs7596

Would like to be able to change the name of a macro in Excel 2003. This may
also be helpful in other Office products (if not already available...). When
developing an "Auto_Open" macro, it is not always convenient to have the
macro execute every time the workbook is opened. Currently, I need to create
a new macro and then cut and paste the "Auto_Open" macro code to the new
macro and delete the "Auto_Open" macro, or got to macro security and change
macro security levels.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d-a6ab57b4bf30&dg=microsoft.public.excel.misc
 
B

Bob Phillips

You should add logic to the macro that tests something ( a cell, a
conditional constant, etc.) to determine whether to run.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

mrs7596 said:
Would like to be able to change the name of a macro in Excel 2003. This may
also be helpful in other Office products (if not already available...). When
developing an "Auto_Open" macro, it is not always convenient to have the
macro execute every time the workbook is opened. Currently, I need to create
a new macro and then cut and paste the "Auto_Open" macro code to the new
macro and delete the "Auto_Open" macro, or got to macro security and change
macro security levels.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/com...d-a6ab57b4bf30&dg=microsoft.public.excel.misc
 
Top