How to go to a predetermined sheet on opening

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Macro for all Excel Workbooks to print to PDF 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Unhide sheet 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
adding footer to all existing sheets in workbook and also to newsheets which is added 1
How to determine which sheets appear on opening a workbook. 6
Set sheet viewpoint on workbook_open() 1

Back
Top