Change Marcro Name

[toulouse330]

Hi,

I have a simple macro that I've created to ToggleHide columns in a single worksheet in my workbook and while the macro works fine, when I click on Macros and see the Macro name, it displays Sheet26Hide_Columns_Toggle. How can I rename this to the actual sheet name instead of the sheet number?

[Richard Buttrey]

Are you talking about the macro procedure name, i.e.

Please Login or Register  to view this content.

or a line of code within the procedure which is referencing Sheet26?

If the former just change the characters 'Sheet26' to whatever you want. The procedure name though can't have any spaces so if your sheet name was say "My Sheet", you'd have to use character in the middle i.e. My_Sheet.


If however you're referring to code which says Sheet26....etc, i.e. the VBA sheet code name then I'd caution you against changing it. Almost without exception references in macros to sheets should always use the sheet Code Name rather than the sheet Tab Name

If you must use the tab name in code then you'd use Sheets("My_Sheet_TabName")