Bring focus to same cell every time opened??

  • Thread starter Thread starter Rita Brasher
  • Start date Start date
R

Rita Brasher

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
 
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
 
Sweet, worked like a charm...
How'd you know I wanted cell "a1"???
Just kidding. LOL

Appreciate it!
Rita
 
Back
Top