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.
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->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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks