default active sheet

[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

 

[Katherine Coombs]

Alldreams,

Are you looking for a non-VBA way of achieving this?

Katherine

 

[Frank Kabel]

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

 

[alldreams]

Hi Katherine,

Yes, non VBA way is what I'd like

thanks!

 

[alldreams]

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!

 

[Frank Kabel]

Hi
AFAIK there is no non VBA way to achieve this. Sorry to say

 

[Frank Kabel]

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

 

[Guest]

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


.