ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   preventing disabling of macros (https://www.excelbanter.com/excel-programming/279091-re-preventing-disabling-macros.html)

Combo[_2_]

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




All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com