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 |