excel2002

[elwyn]

Hi all

Sorry if this has been covered before: Is there any way to make an excel
workbook always open on the same worksheet immaterial of where you actually
saved or closed the workbook?

Many thanks

elwyn

 

[Chip Pearson]

Elwyn,

You need to use a VBA macro to do this. For example,

Sub Auto_Open()
Application.Goto Worksheets("Sheet2").Range("F5"),True
End Sub

This will take Excel to cell F5 on Sheet2 when the workbook is opened.

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

 

[elwyn]

Hi Chip

Thanks for fast reply. That is exactly what I need.

Thanks again

Elwyn


I have copied