Home cell
 

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

Home cell
 

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" wrote:

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

Home cell
 

Sweet!

thank you
--
Jeff


"Mike H" wrote:

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" wrote:

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

Home cell
 

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

On Wed, 17 Dec 2008 12:43:01 -0800, Jeff
wrote:

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!