R
Robert Crandal
In my Workbook_Open() subroutine, I run the following line of code:
Application.Goto Reference:=Sheets("Sheet1").Range("A1"), scroll:=True
This code works okay, but whenever I mark my "Sheet1" as hidden, the
code no longer works. The error message that I get is Run-Time
Error 1004 - Method 'Goto' of Object '_Application' Failed.
Is there any way to use that line of code on a hidden sheet??
thanx
Application.Goto Reference:=Sheets("Sheet1").Range("A1"), scroll:=True
This code works okay, but whenever I mark my "Sheet1" as hidden, the
code no longer works. The error message that I get is Run-Time
Error 1004 - Method 'Goto' of Object '_Application' Failed.
Is there any way to use that line of code on a hidden sheet??
thanx