Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set macro virus protection off/on in Excel-VBA? 1

Status
Not open for further replies.

EdwinBaas

Programmer
Oct 19, 2001
4
NL
Is there a VBA-statement to enable and disable the macro virus protection in Excel?

Edwin
 
That would suprise me learn that it can be done easily through VBA, seeing as it's a security feature designed to thwart virus type scripts.
 
Hi ETID, thanks for your reponse. I understand that it's difficult to handle this in VBA. However you can enable or disable de macro virus check by selecting Tools|Options and check for macro virus chechking. So it shouldn't be impossible. I know in Word this is possible...

EB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top