Save document and return to sheet 1

[shyguy44]

In sheet1 I have a macro button which refreshes data on a daily basis, however the user will be working on sheet2.

When they finish on sheet2 and close the document, when they repen it I want it to open on sheet1

 

[Joe4]

You can add a Workbook_Open event procedure (VBA) that will automatically go to Sheet1 upon opening the workbook (of course, VBA/Macros need to be enable for this to work).

The code would look like this and needs to be placed in the ThisWorkbook VBA module:

Private Sub Workbook_Open()
    Sheets("Sheet1").Select
End Sub

Here is a more detailed write-up on the different Event Procedures:
http://www.cpearson.com/excel/Events.aspx