disable macro virus warning in excel
Posted by marcel on May 15, 2001 12:57 AM
How to disable the maccro virus warning in excel( I,ve already tried it with disable alertwarning but this does not work) and how to disable the message you get when you open an excel file that is linked to another application (both in visual basic)
Posted by Dave Hawley on May 15, 2001 1:19 AM
Hi marcel
It is not possible to prevent the Macro Virus Warning via VBA or VB. I guess if it was possible it would be a useless feature. The only way this can be stopped is via Tool>Options.
To prevent Links fom Updating use:
Workbooks.Open FileName:="C:/MyDocuments/Book1.xls", UpDatelinks:=0
Dave
OzGrid Business Applications
Posted by Ivan Moala on May 15, 2001 6:42 AM
Dave is right, however there is a work around to
this which involves saving a small loader file to
the xlstart dir.
The loader I've developed involves some API calls
to the registry and changing the registration entry.
This entry effectively disables the macro warning
when you next open excel.
I have never posted it as it can be dangerous and
you could if you wanted to do some damage.
Dave if you want to have a look I'll be glad to send it....
Ivan
