Property for the last sheet viewed?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Is there a property that can be set to tell Excel to open a specific sheet. I am looking for an
Excel property that would be used to open a sheet without the use of a macro. I believe I saw one
discussed here, but can't remember what is is?/

Thanks,

Rick
 
Hi Rick

Do you want to have a specific Workbook always open on a specified
Worksheet? If so, it's only possible vai VBA code.

Right click on the Excel icon, top left next to "File" and select "View
Code". In here place;

Private Sub Workbook_Open()
Sheets(1).Select
End Sub

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top