VBA Sheet Name - 1096 - Learn Excel from MrExcel Podcast
Your recorded macros might not work if someone renames a worksheet. Rather than use the worksheet name, use the code name for the worksheet. This name can never be changed and is more reliable. Episode 1096 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
posted by Bill at 9:00 AM
2 Comments:
Bill, I tested to see if this coding would resist to the user moving the sheet "anything we wanted" from 1st position to last. Indeed, this originally first sheet will keep being Sheet1 and the macro will still work!
5:52 PM
Oh yes ...very cool the way that this works. If the macro recorder would start using the code name of the sheet, people would have better code to start customizing.
8:55 AM
Post a Comment
<< Home