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

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

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