Setting default "open" worksheet in a workbook
 

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!
;)


---
Message posted from http://www.ExcelForum.com/

Setting default "open" worksheet in a workbook
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

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!
;)


---
Message posted from http://www.ExcelForum.com/