software

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 quot;Auto_Openquot; 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 quot;Auto_Openquot; macro code to the new
macro and delete the quot;Auto_Openquot; 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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

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)

quot;mrs7596quot; gt; wrote in message
...
gt; Would like to be able to change the name of a macro in Excel 2003. This
may
gt; also be helpful in other Office products (if not already available...).
When
gt; developing an quot;Auto_Openquot; macro, it is not always convenient to have the
gt; macro execute every time the workbook is opened. Currently, I need to
create
gt; a new macro and then cut and paste the quot;Auto_Openquot; macro code to the new
gt; macro and delete the quot;Auto_Openquot; macro, or got to macro security and
change
gt; macro security levels.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...lic.excel.misc