User Disable Macro

[carltremblay]

Hi EveryOne,
I have a nice problem with Word VBA.
If the user Disable Macro on document opening, the user
must NOT see the document. Is there a way to do this ?

- Thanx a lot

[WorkHorse]

Originally posted by carltremblay
Hi EveryOne,
I have a nice problem with Word VBA.
If the user Disable Macro on document opening, the user
must NOT see the document. Is there a way to do this ?

- Thanx a lot

Nope. At least not without running code from a source outside the document. If the document macro are disabled, no code would run so Word wouldn't do anything differently than it normally does. If you have a global template loaded, you could use AutoOpen or subclass the application to check document open events and then check to see if the document has macros disabled and if so then close it, but the user would have had to already allowed the global template to open with macros enabled (and not open the document with Shift pressed if you are using AutoOpen). Another option would be to run an executable that constantly checks Word for documents open with disabled macros and closes them.

A workaround might be to come at it from the other way. Instead of hiding the document if the user disables macros, have the document content hidden in a resource file that is only loaded by a macro. So the document just says "Sorry, you disabled macros. Try again.", but if macros are enabled use an AutoOpen macro to get the contents from the resource document and load them to your document. Then on AutoClose, save the document contents to your resource file and replace the document with the "Sorry, you disabled macros." text.

The best workaround depends on why you want to hide the document when macros are disabled.

[BazP]

i had a similar issue in Excel. The way I got around it was to lock everything when you save the file. So if you open the file disabling macros, everything is still locked, if u enable macros, then include some code in ThisDocument
Private Sub Document_Open()
End Sub
to unlock document.
Also rem to lock document on close

[westconn1]

you can you sign your macros so the enable macro box won't be shown?
your signature will have to be added to the trusted signatures in macro security

pete