View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Open spreadsheet on specific tab

Hi

Paste this event code into the code sheet for ThisWorkbook:

Private Sub Workbook_Open()
Worksheets("Main").Activate
End Sub

Regards,
Per

On 23 Sep., 23:05, Alberta Rose
wrote:
I have a file with multiple worksheets. *I want one specific worksheet called
Main to be opened when the file is opened. *Right now the file opens which
ever worksheet was viewed last before it was closed. *Is there some vba
coding that I could do this with, I've searched, but no luck.

Thanks.