View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
rog rog is offline
external usenet poster
 
Posts: 39
Default How to go to a predetermined sheet on opening

Put this code in the Workbook object :

Private Sub Workbook_Open()
thisworkbook.Worksheets("Sheet to start from").select
end sub

(obviously you need to change the "sheet to start from" !

Rgds

Rog



-----Original Message-----
My workbooks are used by a wide community and are

sometimes saved down again,
with the curser sitting in the body of a sheet. i want to

tell Excel to
always open on a named sheet whenever the workbook is

opened.
.