Dim sht As Worksheet
For Each sht In ThisWorkbook.Sheets
The ideas was replied toHi,
I am trying to rename the workbook module from ThisWorkbook to something else through the properties window. I can change the name fine, but when I close the file and reopen it the workbook module name has reverted back to ThisWorkbook. Any ideas?
Thanks
Thisworkbook is a built in reference to the workbook and should not be renamed.
Why do you want to rename it?
-- Andy Pope, who further expanded why it was a bad idea.I also never use ThisWorkbook since by default they are all ThisWorkbook (and I often forget to rename them)