Forcing Macros to Run

  • Thread starter Thread starter James
  • Start date Start date
J

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
 
Virus protection is exactly that. If code could switch off the protection,
then what would be the point of having protection.
 
Malicious code would exploit that. Search excel help etc for digital
signatures and see if any of that interests you.

Sam
 
Back
Top