Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to change data in inactive sheet | Excel Discussion (Misc queries) | |||
macro to change data in inactive sheet | Excel Discussion (Misc queries) | |||
Macro to change data in a sheet | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Buttons to link to a hidden sheet | Excel Discussion (Misc queries) |