Open Automatically on a particular Worksheet
 

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.

Open Automatically on a particular Worksheet
 

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).

"Fedarni" wrote:

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.