First post, I hope I'm clear enough.
I'm working on a macro which hides/unhides worksheets after a user runs the "build" macros in the workbook (which create a number of new tabs named with values in a list). I'm hoping to find code that will select all the sheets which were built during the previous process. The sheet names in the build process are in a list on a "maintenance" tab so I'm assuming the easiest way to accomplish this is to somehow select the sheets to hide/unhide based on that same list. The problem I'm encountering is that VBA needs to know either the sheet name or the codename, but both of these will change each time the user runs the building macro. Help would be much appreciated!! Thanks!!