| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bring focus to same cell every time opened??
When someone saves a workbook, typically the place (cell) the cursor is
on when saved is where we come back to when the file is reopened later. Is there a way to open the workbook with the focus on the same cell, regardless of where we were in the workbook when the file was saved? Rita Brasher Project Engineer FedEx Express - IPEG International MIS and Training |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bring focus to same cell every time opened??
Hi
Alt+F11 to open VB editor. Double click 'This workbook" Paste this in on the right Private Sub Workbook_Open() Sheets(1).Select Range("a1").Select End Sub Mike "Rita Brasher" wrote: When someone saves a workbook, typically the place (cell) the cursor is on when saved is where we come back to when the file is reopened later. Is there a way to open the workbook with the focus on the same cell, regardless of where we were in the workbook when the file was saved? Rita Brasher Project Engineer FedEx Express - IPEG International MIS and Training |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bring focus to same cell every time opened??
Sweet, worked like a charm...
How'd you know I wanted cell "a1"??? Just kidding. LOL Appreciate it! Rita Mike H wrote: Hi Alt+F11 to open VB editor. Double click 'This workbook" Paste this in on the right Private Sub Workbook_Open() Sheets(1).Select Range("a1").Select End Sub Mike "Rita Brasher" wrote: When someone saves a workbook, typically the place (cell) the cursor is on when saved is where we come back to when the file is reopened later. Is there a way to open the workbook with the focus on the same cell, regardless of where we were in the workbook when the file was saved? Rita Brasher Project Engineer FedEx Express - IPEG International MIS and Training |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Focus on a cell based on date | Excel Worksheet Functions | |||
| how do i have a cell number increase by 1 each time file opened | Excel Discussion (Misc queries) | |||
| Active Cell/Focus | Excel Discussion (Misc queries) | |||
| Temporary formatting of cell with focus | Excel Discussion (Misc queries) | |||
| tool tip to open when the cell has the focus | Excel Worksheet Functions | |||
Hybrid Mode
