software

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

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 amp; brackets)
3. On the right type

Private Sub Workbook_Open()
Sheets(quot;Sheet1quot;).Activate
Range(quot;A15quot;).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 amp; 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 auquot;mwclark0807quot; wrote:

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

Julie,

Thanks that worked like a charm.

Mitch

quot;JulieDquot; wrote:

gt; Hi
gt;
gt; You'll need to use code to achieve this
gt;
gt; 1. Right mouse click on a sheet tab and choose VIEW CODE
gt; 2. In the VBE window that is displayed, on the left (in the Project Explorer
gt; window) double click on ThisWorkbook (under where your workbook name is
gt; displayed in bold amp; brackets)
gt; 3. On the right type
gt;
gt; Private Sub Workbook_Open()
gt; Sheets(quot;Sheet1quot;).Activate
gt; Range(quot;A15quot;).Select
gt; End Sub
gt;
gt; 4. Put the sheet name in the place of Sheet1 (if necessary)
gt; 5. Put the cell reference in place of A15
gt; 6. Use ALT amp; F11 to switch back to your workbook
gt; 7. Choose Tools / Macros / Security and ensure that the security level is
gt; set to MEDIUM
gt; 8. Save and close the workbook
gt;
gt; When you open it next time, and choose to ENABLE MACROS it should do what
gt; you want.
gt;
gt; Hope this helps
gt;
gt; --
gt; Cheers
gt; JulieD
gt;
gt; julied_ng at hctsReMoVeThIs dot net dot au
gt;
gt;
gt; quot;mwclark0807quot; wrote:
gt;
gt; gt; Is there a way to have a cell always be the active cell when a workbook is
gt; gt; opened?

you're welcome
--
Cheers
JulieDjulied_ng at hctsReMoVeThIs dot net dot auquot;mwclark0807quot; wrote:

gt; Julie,
gt;
gt; Thanks that worked like a charm.
gt;
gt; Mitch
gt;
gt; quot;JulieDquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; You'll need to use code to achieve this
gt; gt;
gt; gt; 1. Right mouse click on a sheet tab and choose VIEW CODE
gt; gt; 2. In the VBE window that is displayed, on the left (in the Project Explorer
gt; gt; window) double click on ThisWorkbook (under where your workbook name is
gt; gt; displayed in bold amp; brackets)
gt; gt; 3. On the right type
gt; gt;
gt; gt; Private Sub Workbook_Open()
gt; gt; Sheets(quot;Sheet1quot;).Activate
gt; gt; Range(quot;A15quot;).Select
gt; gt; End Sub
gt; gt;
gt; gt; 4. Put the sheet name in the place of Sheet1 (if necessary)
gt; gt; 5. Put the cell reference in place of A15
gt; gt; 6. Use ALT amp; F11 to switch back to your workbook
gt; gt; 7. Choose Tools / Macros / Security and ensure that the security level is
gt; gt; set to MEDIUM
gt; gt; 8. Save and close the workbook
gt; gt;
gt; gt; When you open it next time, and choose to ENABLE MACROS it should do what
gt; gt; you want.
gt; gt;
gt; gt; Hope this helps
gt; gt;
gt; gt; --
gt; gt; Cheers
gt; gt; JulieD
gt; gt;
gt; gt; julied_ng at hctsReMoVeThIs dot net dot au
gt; gt;
gt; gt;
gt; gt; quot;mwclark0807quot; wrote:
gt; gt;
gt; gt; gt; Is there a way to have a cell always be the active cell when a workbook is
gt; gt; gt; opened?