Hi! I have an auto open macro that opens the same worksheet every time:
Sub auto_open()
Sheets("Sheet1").Select
Beep
End Sub
There are, however, multiple worksheets in my workbook and I want the macro to open the worksheet that was open when the file wasa last closed, i.e. If "Sheet3" was the last worksheet in use when last session was terminated, then the next user to open the file should find "Sheet3" open when the new session is launched.
Any suggestions out there?
Sub auto_open()
Sheets("Sheet1").Select
Beep
End Sub
There are, however, multiple worksheets in my workbook and I want the macro to open the worksheet that was open when the file wasa last closed, i.e. If "Sheet3" was the last worksheet in use when last session was terminated, then the next user to open the file should find "Sheet3" open when the new session is launched.
Any suggestions out there?