Open and Refresh All sheets using macros

Question

Hi i have a workbook with a particular sheet i want displayng whenever the work  book was launched.

i have these macros one is to open the sheet designated the other to refresh the data within the book.

rereshing data macro

Sub RefreshPivotTables()

   Application.ScreenUpdating = False

     ActiveWorkbook.RefreshAll

   Application.ScreenUpdating = False

 End Sub

opening sheet

Private Sub Workbook_Open()

     Me.Worksheets("HOME_PAGE").Select

 End Sub

How will these two work together instead of manualy reshing i intend to let it refresh just after the book was opened.

thanks for your time.

i will be hiden all my sheet tabs as well.

Answer 1

Try

Private Sub Workbook_Open()

    Application.ScreenUpdating = False

    Me.RefreshAll

    Application.ScreenUpdating = True

    Me.Worksheets("HOME_PAGE").Select

    ActiveWindow.DisplayWorkbookTabs = False

End Sub

Answer 2

Thanks a lot HansV