MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2000 Macro/Virus warning

Posted by Adams on August 09, 2001 7:52 AM

I am posting a link to an excel document on a site. Once the WB is opened through the link the macro virus warning appears. I tried writing a macro that sets the "display alerts" to false-that didn't work. I also tried setting the security to low-this changes the setting to low for excel completely, leaving users at risk for a virus. Could I write a macro that sets the security to low on open, then re-write a macro that sets it back to medium on close? Any help is appreciated! Thanks

Posted by Rob Jackson on August 09, 2001 8:25 AM

I could be wrong but I think you'll find that the message appears before any code is run. There is no way for an opening workbook to disable it using code. What you need to do is to look at network digital certification. Basically this is applied to a workbook by the network administrator and validates it as ok and virus free. The system will then open without asking. Look up digital certification in the excel help file.

Posted by Dax on August 09, 2001 4:27 PM


Rob is indeed right. There is no point in having macro virus protection if any old half educated dick head can come along and write a macro which will delete all of your system files. VBA is a very powerful language which can do practically anything you want - Look at Melissa for one.