View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default Forcing Macros to Run

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

Sam

"James" wrote:

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