W
Wuddus
I have a very simple macro that, when run, takes the user to a specified
location on another sheet in the same workbook:
Sub ToProjectInfoPage()
Sheets("Project Info").Select
Range("A1:E1").Select
End Sub
This works fine when the destination sheet ("Project Info") is visible, but
when it's hidden, the macro returns an error.
Is there a way to fix the macro so that it works when the destination sheet
is hidden?
Thanks in advance!
location on another sheet in the same workbook:
Sub ToProjectInfoPage()
Sheets("Project Info").Select
Range("A1:E1").Select
End Sub
This works fine when the destination sheet ("Project Info") is visible, but
when it's hidden, the macro returns an error.
Is there a way to fix the macro so that it works when the destination sheet
is hidden?
Thanks in advance!