Setting default "open" worksheet in a workbook

W

Worsty

I have an Excel workbook with multiple worksheets included. I want to
set a specific worksheet as the default when opened.

Is this possible and if so how do I do it? If it is a macro could you
give me the code?

Thanks Much!
;)
 
F

Frank Kabel

Hi
put the following code in your workbook module
Private Sub Workbook_Open()
Worksheets("your sheet name").activate
End Sub
 
Top