Macro names are being renamed automatically

After running a macro processing step – you find that the name of the macro has changed in the source workbook. Most commonly, the macro has been renamed to include an underscore character as a prefix.

Why does this happen?

If a macro contains words or expressions that are considered ‘reserved words’ by Excel – then the underlying technologies will automatically rename them.

How to fix this

Try to avoid using macro name that is short and alphanumeric. For example, ‘ABC123’. ‘ABC123’ is cell address in Excel 2007. If you have macro with similar kind of name, then please rename it with ‘ABC_123’.

[divider]
Recommended Posts

Leave a Comment