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.
.
|