MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disable Macros


Posted by Siva on June 12, 2001 6:54 AM

Hi All,

im instantiating xl appln from my VB code.This xl appln comes with the xl msgbox "Enable/Disable Macros".How to avoid this msg being popped up every time.
Thanks in advance

Siva


Posted by ZEN on June 12, 2001 7:26 AM

hi siva, i've been asking about this myself, and the quick answer is you can't, as some explained on these pages it would be very dangerous to do it, it's minor set back but hey at least you'll sleep easy at night knowing the some virus has snuck in and killed all your files.

sorry it's not the answer you want,

zen

Posted by ZEN on June 12, 2001 7:26 AM

hi siva, i've been asking about this myself, and the quick answer is you can't, as some explained on these pages it would be very dangerous to do it, it's minor set back but hey at least you'll sleep easy at night knowing the some virus has snuck in and killed all your files.

sorry it's not the answer you want,

zen