preventing disabling of macros

[nhl]

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.

 

[Earl Kiosterud]

nhl,

If you find a way to do this, please report it. It would be a serious bug
in Excel. The whole idea is to give the user control of running macros,
since they can be malevolent. Viruses and stuff.

Earl Kiosterud
mvpearl omitthisword at verizon period net

 

[Dan E]

NHL,

No, thank goodness, wouldn't that sort of defeat the purpose
of macro security...

You can take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo00/html/combat.asp
to create your own digitals signature, sign your macros and
then people can choose whether or not to trust you and if
they do, the warning won't be displayed any longer...

Dan E

 

[Combo]

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