When opening excel

[abee4life]

Is there a code i can insert to make it always open on the 'Home' Page?

When i save, i may save it on a different page, but when opening it i want it opened on 'Home'

please help

 

[Tazguy37]

If you mean to active the worksheet named "Home" in a particular workbook, then something like this could be used in the Workbook_Open() event:

Private Sub Workbook_Open()
    On Error Resume Next
    Worksheets("Home").Activate
End Sub

• How to use the above code:
  
  Press Alt-F11 to open the VBE.
  Press Control-R to open the Project Explorer.
  Click "Microsoft Excel Objects" for the file you're working on.
  Double-click the ThisWorkbook module.
  Paste the above code in.
  Press Alt-Q to close the VBE and return to Excel.

Hope that helps!

 

[abee4life]

worked like a charm!