Sep 19 2018 06:45 AM - edited Sep 20 2018 01:50 AM
Hi all,
I would like open a specific worksheet whenever i open my excel irregardless where is my last save.
I have performed the following actions:
1) I have written the following in VBA project:
Private Sub Workbook_Open()
Worksheets(“Sheet1”).Activate
Range(“A1”).Select
End Sub
2) I have save it as macro enable worksheet as well.
However, when i open the file, it pop out run time error and unable to jump to the worksheet as written in VBA. I have attached the excel file as well. Please advise.
Thanks & regards,
Kia Boon
Sep 20 2018 08:58 PM
the problem is the double quotation mark. I corrected them pls see attached file..
HTH
Sep 21 2018 08:43 PM
Thanks! I didn't know that mark could make the whole macro unable to run.
Sep 21 2018 08:45 PM
Aug 07 2021 08:03 AM
What, exactly, is the problem with the double quote?
Thank you.
Aug 07 2021 10:27 AM