Specific cell selected upon opening sheet

[dago]

Hi,

I cannot figure out how to have the selection of a cell on opening a sheet NOT automatically on cell A1. I want to be able to set the selection on opening a sheet per sheet. Do I need to set a Private Sub on each corresponding Sheet? And how would the code be?

(Let's say the user of my speadsheet has to start working in cell F15 on a given sheet)

Thanks in advance, Dago

 

[Larry_S]

If a certain cell is selected on a sheet when the workbook is saved to disk, then that is the selected cell on that sheet when the workbook is opened the next time.

Also, look into locking the cells on your sheets, except for those where the user can enter data. Then when the user presses the tab key, the selection moves to the next unprotected cell. After setting the cells to locked or unlocked, you need to protect the worksheet to get Excel to pay attention to the locking information.

If you need more positive control, then you would need to create a macro to run automatically when the workbook was opened.
For each worksheet in the workbook, you would need to do the following two statements in your macro:

Worksheets("Sheet2").Activate
Worksheets("Sheet2").Range("F15").Select

Don't forget to activate the sheet where you want the user to start as the last statement of your macro.