One way to 'force' 99% of users to enable macros is to save the file as a template and store the desired contents in a building block but leave a notice in the document that tells them they must enable macros to see the contents.
An automacro could then run to replace the notice with the building block if the date hasn't been exceeded.
This method isn't completely foolproof but it might make it harder for them to figure out work arounds. You would probably want to also block Copy/SaveAs/Print options to increase the protection.
As the others have indicated, there will always be workarounds that clever users can use to circumvent your protection methods.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|