Set Active Cell to A1 on Open Q
change the inside of the for/next loop to this:
if sh.visible then
application.goto sh.range("A1"),true
end if
On Feb 16, 10:13*am, Seanie wrote:
I have the code below which moves all sheets active cell to A1, but
how do I tweak to also do so when I have hidden worksheets? Currently
it debugs as I have some sheets hidden
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
* sh.Select
* Application.Goto Reference:=sh.Range("a1"), Scroll:=True
Next sh
ThisWorkbook.Sheets("Month").Select
Application.ScreenUpdating = True
End Sub
|