View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Force excel to open on a specific sheet

You could use a macro:

This goes in a General module--not under ThisWorkbook and not behind a
worksheet:

Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("sheetnamehere").range("a1 "), _
scroll:=true
End sub

Change the sheetnamehere to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

harwookf wrote:

Is there a way to force excel to open on a specific sheet?

I have 4 worksheets within the workbook, but need it to always open on a
certain one.


--

Dave Peterson