View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wuddus Wuddus is offline
external usenet poster
 
Posts: 24
Default Macro Error When Connecting to Hidden Sheet

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!