Open spreadsheet on specific tab
Hi
Paste this event code into the code sheet for ThisWorkbook:
Private Sub Workbook_Open()
Worksheets("Main").Activate
End Sub
Regards,
Per
On 23 Sep., 23:05, Alberta Rose
wrote:
I have a file with multiple worksheets. *I want one specific worksheet called
Main to be opened when the file is opened. *Right now the file opens which
ever worksheet was viewed last before it was closed. *Is there some vba
coding that I could do this with, I've searched, but no luck.
Thanks.
|