excel2002

  • Thread starter Thread starter elwyn
  • Start date Start date
E

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
 
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
 
Hi Chip

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

Thanks again

Elwyn


I have copied
 
Back
Top