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’.

Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox