Active Cell when opening workbook

[mwclark0807]

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

[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

--
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?

[mwclark0807]

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?

[JulieD]

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?