| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Macro to take me to first cell of the first sheet
I am looking to create a macro which enables me to open a file at the cell A1
on the first sheet, no matter where I was when i closed the file. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a Macro to take me to first cell of the first sheet
Under the workbook_open event use this line of code
Sheets(1).Range("A1").Activate Charles Chickering xl Geek Rob wrote: I am looking to create a macro which enables me to open a file at the cell A1 on the first sheet, no matter where I was when i closed the file. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a hyperlink to a cell on a different sheet | Excel Worksheet Functions | |||
| Creating Excel 4 International Macro Sheet | Excel Programming | |||
| Creating Macro to edit cell | Excel Programming | |||
| Creating an Excel sheet with Addresses using a Macro | Excel Programming | |||
| Run Macro & Rename Sheet upon creating copy from blank. | Excel Programming | |||
Hybrid Mode
