Open spreadsheet on specific tab
It works a charm, thanks :)
"Per Jessen" wrote:
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.
|