Thread: Always open in the same place...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RichardSchollar[_3_] RichardSchollar[_3_] is offline
external usenet poster
  
Posts: 1
Default Always open in the same place...

Hi Samuel

You need to place the following code in the ThisWorkbook module of the
workbook:


Private Sub Workbook_Open()
Sheets("User Select").Activate
End Sub

Which will automatically activate the given sheet when the workbook is
opened.

Hope this helps!

Richard


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698
View this thread: http://www.excelforum.com/showthread...hreadid=545788

Reply With QuoteReply With Quote