View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Open Specific Worksheet

You need to use a VBA macro:

Sub Auto_Open()
ThisWorkbook.Worksheets("Sheet4").Select
End Sub

Change "Sheet4" to you desired worksheet.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"cargor"
wrote in message
...

When Excel opens, I would like a specific worksheet to
open. If someone could help i would be greatful!


--
cargor
------------------------------------------------------------------------
cargor's Profile:
http://www.excelforum.com/member.php...o&userid=36300
View this thread:
http://www.excelforum.com/showthread...hreadid=560761