Active Cell when opening workbook
 

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

Active Cell when opening workbook
 

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


"mwclark0807" wrote:

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

Active Cell when opening workbook
 

Julie,

Thanks that worked like a charm.

Mitch

"JulieD" wrote:

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


"mwclark0807" wrote:

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

Active Cell when opening workbook
 

you're welcome
--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"mwclark0807" wrote:

Julie,

Thanks that worked like a charm.

Mitch

"JulieD" wrote:

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


"mwclark0807" wrote:

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