View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Combo[_2_] Combo[_2_] is offline
external usenet poster
 
Posts: 4
Default preventing disabling of macros


The way to work around of this is protect the workbook.
On Auto_open() sub, you put a single command to unprotect it.

That way , your file will be able to work/view, only if the Enable
Macros was selected.

That's



"nhl" escreveu na mensagem
...
Is there any way to prevent the ability of a user to
disable macros for a particular file?

Perhaps a program that runs upon opening a document that
changes the security settings to low??

Thanks.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 29/9/2003