I have a tab in my workbook called "Macro" in which I have hard keyed the names of specific sheets within my workbook. My current code uses this "Macro" tab to "know" on which tabs to execute my code, my code could be hidding blank rows, showing hidden columns, printing tabs to .pdf and saving on sharepoint, etc.
Instead of using a "Macro" tab, I would like to have my macro go through each worksheet and check if a value is present in a certain cell. For example, go to sheet 1 if cell A1 = "Publish" then execute code, then go to sheet 2 and repeat until its gone through all sheets in the workbook. If cell A1 doesn't equal publish then go to the next sheet.
I want to empower my users to decide which sheets to include, and I also dont want to have to manage my old "Macro" tab anymore.
Bonus points would be for it to only go through visible sheets (I have many hidden sheets that would never be included in this process)
Instead of using a "Macro" tab, I would like to have my macro go through each worksheet and check if a value is present in a certain cell. For example, go to sheet 1 if cell A1 = "Publish" then execute code, then go to sheet 2 and repeat until its gone through all sheets in the workbook. If cell A1 doesn't equal publish then go to the next sheet.
I want to empower my users to decide which sheets to include, and I also dont want to have to manage my old "Macro" tab anymore.
Bonus points would be for it to only go through visible sheets (I have many hidden sheets that would never be included in this process)