Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Active Cell when opening workbook
Is there a way to have a cell always be the active cell when a workbook is
opened? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract just the Column Name of the active cell | Excel Discussion (Misc queries) | |||
Active cell moves off the screen | Excel Discussion (Misc queries) | |||
Active Cell displayed in another cell? | Excel Discussion (Misc queries) | |||
Unable to set the active cell from VBA | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |