#1
|
|||
|
|||
Restricted editing disables macro
I created a template with a text field and a form field. I created a macro so the user could hide and unhide the data in the form field however when I restrict editing the macro disappears and says "the requested member of the collection does not exist. Below is the VB. I am also saving as a macro enables template.
Sub MYMACRO() ActiveDocument.Bookmarks("TextToShow").Range.Font. Hidden = Not ActiveDocument.Bookmarks("TextToShow").Range.Font. Hidden End Sub |
#2
|
||||
|
||||
Your error message suggests the 'TextToShow' bookmark has been deleted. As for being unable to access the macro via Alt-F8 or Alt-F11 once forms protection is applied, that is normal.
In any event, trying to hide content in a by toggling the font's hidden state is quite unreliable. Whether it actually works depends on how the user has Word configured. Whether the text does hide, or whether it gets printed, is entirely beyond the macro's control. With the font hidden state, there are four possibilities. The hidden text will : 1. neither display nor print 2. display but not print 3. print but not display 4. both display and print For users who have Word configured to show formatting marks (a quite common setup),'2' is the most likely outcome.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Building Block Gallery Content function on a form with restricted editing | wes228 | Word VBA | 1 | 08-28-2014 08:14 AM |
Specifying a user in restricted editing | Ulodesk | Word | 2 | 05-24-2014 12:09 PM |
Highlighting from Restricted Editing | Invicta | Word | 3 | 11-08-2012 06:05 AM |
Restricted Formatting & Editing | dani | Word | 1 | 11-08-2012 01:09 AM |
Restricted Fonts—but which ones? | Phrixos | Office | 6 | 02-17-2012 07:39 PM |