auto open specific worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I set a workbook to automatically open to the
specific worksheet I want when I open the workbook?
 
The workbook will open up where you were when it was last saved, so, select
the worksheet and even the cell where you want to be when you open the
workbook, and save it. Close it and re-open it, it should take you to the
same spot you were when you saved and closed it.

hth,
Dan
 
You can paste the following code in the workbook:

Private Sub Workbook_Open()
Sheets("Sheet2").Select
Range("A1").Select
End Sub

Replace Sheet2 and A1 as needed.

To access the workbokk's code right-click a sheet ta and
select 'View Code'. Once the VB editor opens select
the 'This Workbook' option that appears under your file
name and paste the code in the window that opens to the
right. Close the editor and go back to excel. Save the
workbook and colse, it will open to that Sheet next time.
Note: Some security settings might disable macros
automaticaly.

Regards,
Felipe
 
Back
Top