Open Automatically on a particular Worksheet

[Guest]

I have a spredsheet that is updated by many. How can I make it so that
spreadsheet, no matter which worksheet the last person saved in, always opens
on the first worksheet.

 

[Guest]

You could open the Workbook and go to Tools->Options->Visual Basic Editor,
then in the Project Explorer pane on the left side of the screen,
double-click on ThisWorkbook and then paste in the following code:
Private Sub Workbook_Open()
Sheets(1).Select
End Sub
Of course, everyone would have to either set Macro Security on their
computers (Tools->Macro->Security) to Medium and select to Enable the macros
when the workbook opens, or set it to Low (not recommended).