Starting a MS Excel workbook with a particular worksheet
 

When I open a workbook, it always does with SHEET 1. How do I start it with a
worksheet other than SHEET 1? I think it is useful when renaming the
worksheets.

Thanks

Excel will open to the worksheet when the file last saved unless you use a
workbook_open or auto_open event to goto the worksheet desired.

--
Don Guillett
SalesAid Software

"icasaresg" wrote in message
...
When I open a workbook, it always does with SHEET 1. How do I start it
with a
worksheet other than SHEET 1? I think it is useful when renaming the
worksheets.

Thanks

Excel will help by opening to the worksheet that was active when you last saved
it.

You could have a macro that runs when you open the workbook that goes to a
particular cell:

Option Explicit
Sub Auto_Open()
application.goto worksheets("sheet3").range("b19")
end sub

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



icasaresg wrote:

When I open a workbook, it always does with SHEET 1. How do I start it with a
worksheet other than SHEET 1? I think it is useful when renaming the
worksheets.

Thanks

--

Dave Peterson

Dave P. has provided code to open an existing workbook at the sheet of your
choice.

If you are perchance asking how to create New workbooks with a sheetname other
than Sheet1 as default..........

Create a new workbook, re-name Sheet1 to a name of your choice.

Delete the other sheets and FileSave AsFile Type MS Excel Template(*.xlt)
and name it BOOK. Excel will add the .XLT.

Store this book in your XLSTART folder and it will become the default FileNew
Workbook.


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 09:21:02 -0800, icasaresg
wrote:

When I open a workbook, it always does with SHEET 1. How do I start it with a
worksheet other than SHEET 1? I think it is useful when renaming the
worksheets.

Thanks