Forcing Macros to Run

[James]

I developed a spreadsheet that has vba code and I would like to make sure the
code always runs. I would like to either disable the prompt to disable/enable
macros when the spreadsheet opens or force the user to have to enable macros.
First when I try setting the security level to "Low" it doesn't save, it
reverts back to Medium. A second approach it to display a warning page if the
user selected "disable macros" and hide all the other pages. This is ok, but
the problem is I also have code that disables the menu items. Since they are
bypassing this they have access to the menu system. I might be making too
much of this, but is their a way to disable the menu items even when they do
not select "enable macros" and/or is their a way to force a user to have to
select "enable macros" or disable the prompt?
Thanks

 

[Patrick Molloy]

Virus protection is exactly that. If code could switch off the protection,
then what would be the point of having protection.

 

[Sam Wilson]

Malicious code would exploit that. Search excel help etc for digital
signatures and see if any of that interests you.

Sam