View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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/