Active Cell when opening workbook

M

mwclark0807

Is there a way to have a cell always be the active cell when a workbook is
opened?
 
J

JulieD

Hi

You'll need to use code to achieve this

1. Right mouse click on a sheet tab and choose VIEW CODE
2. In the VBE window that is displayed, on the left (in the Project Explorer
window) double click on ThisWorkbook (under where your workbook name is
displayed in bold & brackets)
3. On the right type

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

4. Put the sheet name in the place of Sheet1 (if necessary)
5. Put the cell reference in place of A15
6. Use ALT & F11 to switch back to your workbook
7. Choose Tools / Macros / Security and ensure that the security level is
set to MEDIUM
8. Save and close the workbook

When you open it next time, and choose to ENABLE MACROS it should do what
you want.

Hope this helps
 
M

mwclark0807

Julie,

Thanks that worked like a charm.

Mitch

JulieD said:
Hi

You'll need to use code to achieve this

1. Right mouse click on a sheet tab and choose VIEW CODE
2. In the VBE window that is displayed, on the left (in the Project Explorer
window) double click on ThisWorkbook (under where your workbook name is
displayed in bold & brackets)
3. On the right type

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

4. Put the sheet name in the place of Sheet1 (if necessary)
5. Put the cell reference in place of A15
6. Use ALT & F11 to switch back to your workbook
7. Choose Tools / Macros / Security and ensure that the security level is
set to MEDIUM
8. Save and close the workbook

When you open it next time, and choose to ENABLE MACROS it should do what
you want.

Hope this helps

--
Cheers
JulieD

julied_ng at hctsReMoVeThIs dot net dot au
Click to expand...
 
Top