Should be able to change name for a macro
 

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/comm...lic.excel.misc

Should be able to change name for a macro
 

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" wrote in message
...
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/comm...lic.excel.misc