Home cell

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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!
 
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
 
Sweet!

thank you
--
Jeff


Mike H said:
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
Click to expand...
 
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
 
Back
Top