I have to quick questions. At the end of one of my macros I need to move three sheets to the very front of the line and scroll to see those tabs. The sheets in order are "Macro", "Data", and "MyChart". I've been using:
Sheets("Macro").Select
Sheets("Macro").Move before:=Sheets(1)
...
but I get a runtime 1004 error. Any ideas?
My second question is if there is a way to hide/unhide sheets in VBA. I have about 35 sheets in my workbook. I would like to hide them all, but the macros need them to not be hidden, so can I just have them appear for the macro to use? Thanks for the help.
Sheets("Macro").Select
Sheets("Macro").Move before:=Sheets(1)
...
but I get a runtime 1004 error. Any ideas?
My second question is if there is a way to hide/unhide sheets in VBA. I have about 35 sheets in my workbook. I would like to hide them all, but the macros need them to not be hidden, so can I just have them appear for the macro to use? Thanks for the help.