Checkbok Unhide/Hide

Originally Posted by kingewing

The sheets are ordered Setup then Master but when I look under the Objects menu in VBA it says Sheet1 (Master), Sheet2 (Setup)...

In code when you refer to a worksheet by index.
Worksheets(1) it refers to the order of the tabs from left to right.
If you move the tabs around you have effectively changed the index order of the sheets.

When you look in the VBE and you see Sheet1(Master), Sheet2(Setup)

The name in the ( ) is the tab name of the sheet. If you change the tab name this name will change.
The Sheet1 is the code name that Excel knows the sheet by. If you highlight one of your sheets in the VBE and choose F4 to display the properties window you will see a name property and you will see it says Sheet1 if you selected Sheet1. You can then change this name and the left hand name will change, but the tab name will stay the same. The beauty of this name is you can use it in code and it will always refer to the same sheet and you don't have to worry about someone changing the tab name and causing problems with the code. The other benefit is if you use this name intellisense is available by just typing that code name and a dot.

Hi again,

Take a look at the attached workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be changed to suit your own workbook layout.

Hope this helps - please let me know how you get on.

Regards,

Greg M