Thread: [Solved] macro enable disable issue
View Single Post
 
Old 11-17-2011, 12:33 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

hi David,

To be able to lock (ie protect) only certain parts of a document, you're presumably using forms protection and Section breaks.

In that case, a Document_Open macro in the document's 'This Document' module could be used to unprotect the Sections that shouldn't be locked. This could be extended to unlocking formfields, etc, if you use them. A Document_Close macro would reverse the process. If the user prevents macros from running, they wouldn't get access to the editable Sections.

As for automatically closing the document, that would require a macro - which would be susceptible to the same macro permission issue.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote