MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Open Excel from VB without running excel Macros

Posted by Nat on May 03, 2001 9:44 AM

Hi All ,

Can somebody help me with this one - Thanks in advance.

I am trying to open an Excel Work Book which has events in Work book open event . When I open it in VB , I dont want the Macros to fire . Can I protect the sheet in VB w/o using Open . Or can I disablke the macros in excel when opening from VB.



Posted by JooBoe on May 03, 2001 10:47 AM

go to tools--options--general..tick the macro virus
protection..when u open your excel..choose disable