Forum Discussion

Kia Boon Goh's avatar
Kia Boon Goh
Copper Contributor
Sep 19, 2018

Activate specific sheet when open excel

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 projec...
excel
Macros and VBA
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 21, 2018

the problem is the double quotation mark. I corrected them pls see attached file..

HTH

 

Kia Boon Goh's avatar
Kia Boon Goh
Copper Contributor
Sep 22, 2018

Thanks! I didn't know that mark could make the whole macro unable to run.

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 22, 2018
    I've seen others made that kind of mistakes too.
    glad to help..

Resources