default active sheet

  • Thread starter Thread starter alldreams
  • Start date Start date
A

alldreams

is there a way to set the default active worksheet? I
want to be able to save on sheet2 and have Sheet1 as my
default active sheet when I open the file..

your help is much appreciated
 
Hi
one way: put the following code in your workbook module:
Private Sub Workbook_Open()
Worksheets("Sheet3").activate
End Sub

change the name of the sheet for your specific worksheet
 
by workbook module you mean macro? there is no macro in
that workbook. I right click on the sheet's tab,
selected view code, and enter the code there. it didn't
work. Any other suggestions?

thanks!
 
Hi
you have to put this code in the workbook module. Try the following
- open your workbook
- Hit Alt-F11 to open the VBA editor
- in the left explorer tree double click onf 'ThisWorkbook' (should be
the first entry for your project)
- insert the code in this editor window
- close the VBA editor
- save your workbook
 
thank you
-----Original Message-----
Hi
you have to put this code in the workbook module. Try the following
- open your workbook
- Hit Alt-F11 to open the VBA editor
- in the left explorer tree double click onf 'ThisWorkbook' (should be
the first entry for your project)
- insert the code in this editor window
- close the VBA editor
- save your workbook

--
Regards
Frank Kabel
Frankfurt, Germany


.
 
Back
Top