View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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