Home cell

[Jeff]

Is there a way to have a workbook start up in a "Home Cell"?

I would like the users to start in the same cell every time they open the
workbook.

thanks!

 

[Mike H]

Jeff,

Alt+F11 to open VB editor. double click 'This Workbook" and paste this in on
the right

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Select
End Sub

Change the sheet and range to suit

Mike

 

[Jeff]

Sweet!

thank you
--
Jeff

Jeff,

Alt+F11 to open VB editor. double click 'This Workbook" and paste this in on
the right

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Select
End Sub

Change the sheet and range to suit

Mike

 

[Gord Dibben]

Either manually save the workbook with that cell selected or use event code
when closing or opening.

How about when you open?

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate 'edit sheetname to suit
Range("G22").Select 'edit cell to suit
Application.Goto ActiveCell, Scroll:=True 'will place G22 at top left
End Sub

Right-click on the Excel Icon left of "File" and select "View Code"

Copy/paste the code into that module. Edit to suit then Alt + q to return
to the Excel window.

Save and close the workbook then re-open for the code to work.


Gord Dibben MS Excel MVP