software

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.

You could open the Workbook and go to Tools-gt;Options-gt;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-gt;Macro-gt;Security) to Medium and select to Enable the macros
when the workbook opens, or set it to Low (not recommended).

quot;Fedarniquot; wrote:

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