opening worksheet

[maui172]

If I have a worksheet with multiple sheets, how do I set it to always
open sheet 1 when someone opens the file. Thanks.

Bill - new member of the group
Boulder, CO

 

[FSt1]

hi
a worksheet open event might work.
Private Sub Workbook_Open()
Sheets("Sheet1").Activate
End Sub
if you have never worked with macros...see this site...
http://www.mvps.org/dmcritchie/excel/getstarted.htm

regards
FSt1