PDA

View Full Version : Go to top of sheet



Odyrus
06-01-2011, 06:33 AM
Go to the top of a sheet when that sheet is selected. The premise seems simple enough to me and I get it for a single sheet, however, I'm trying to apply this to all sheets in my workbook, even newly added ones, and I'm missing something. Any thoughts?

Cheers!

mikerickson
06-01-2011, 07:24 AM
You could put this in the ThisWorkbook code module

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.Goto Sh.Cells(1, 1), True
End Sub

Odyrus
06-01-2011, 07:32 AM
Thank you sir! :)

Cheers!

mikerickson
06-01-2011, 07:47 AM
Walkenbach's Power Programming book is a good one.

Odyrus
06-01-2011, 07:54 AM
I'll have to look into then, thank you!