Auotomatically Enable Macros by a macro

If you're using Excel 2000/2002 you can use digital signatures and get each of your users to add your signature to their list of trusted sources. This costs money and might be overkill. As for disabling macros, you can't do this in your log. If a workbook could override macro protection then it would mean that protection would be totally ineffective. Virus writers would just override the Enable/Disable macros dialog and go on to execute whatever code they want.

Regards,
Daniel.

Hi Daniel and Alex
macro protection is a must, we all know its a big pain, set to high, Ok this is my opinion not a rule, and im just offering my point of view, hows right ?? I really dont know, whats best for them i guess. BUT....

Yes disable protection is how Virus Programmers bug/jump the protection to trip Excel into a dangerouse program, i dilike this and campaign against it. my view is set Virus Checker to HIGH and full read write upload and download, i check updates everyday sometimes twice, and set macros to high, i have no trusted sources, as i dont TRUST, if i get Attachment i dont like or expect i delete it without looking, OK a big opver the top but all the lates Virus i know people who have been hit by them, and im th eone call de disenfect the Network or PC's, so i say the same, NEVER has a friend been hit twice.

Its worth remembering the Virus Checkers are worthless in general as they only protect you from whts know, not the new virus, so Macro protection is a must to offer a double check then you can lokk and say OK or NO, it takes seconds, and then click OK a small price o think dont you feel?

On that note Macro Virus run ion Kernal32.exe like the BadTransB virus and when its damaged - infected - its gone for ever and rebuild is all you can do, likewise the Macro virus are Network aimed and damage data not send emails as they have poor technology to do this VBA is slow and not good at sending Email to spread the nasty virus so its very goodat its job trash a network at 100MB per secont min is not common, and infection at 100%, nasty!

But i add Macro virus are all but dead now as programmers seam board of them and the killers of email attachments rule the World wide web, days of floppy with Macro virus are dying, BUT keep your guard up ALWAYS, if you dont know DELETE.

Jack in UK

Hi

What you can do is have a Main Page that says on it "You must enable macros too work" and have all oher pages hidden.

On the workbook_open event hide the page and show the pages you want.

On the workbook_close event hide all pages and show the main page

This way they cant do anything with your program except stare at the main page unless they enable their macros.

Jacob

Jacob, thanks it is a good idea

-alex