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!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.