Solved

Section of word document as read only ?

Posted on 2006-11-10
14
3,128 Views
Last Modified: 2008-08-22
I would like to be able to 'lock' parts of a word document.  Eg have a table and prevent the user modifying/deleting the contents of *SOME* cells in the table.  (Maybe an embedded field of some kind in the cell?)

The document will be created by automation and some information the end user is not allowed to modify or delete.

Is it possible? and if yes then how?  


BTW Having an embedded excel sheet is NOT an option.
0
Comment
Question by:AndyAinscow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 4
  • 2
14 Comments
 
LVL 22

Expert Comment

by:Dreamboat
ID: 17915181
Very difficult to lock PARTS of a table, but certainly not parts of a document. Here's my article that explains how:
http://www.officearticles.com/word/protecting_parts_of_a_document_in_microsoft_word.htm
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 17915249
Thanks, I've had a quick look at the link.  It doesn't look suitable.  Unless I misunderstand it only works on 'horizontal stripes' that are the complete width of the document.

eg.
Table with 3 columns and 2 rows.
I might want to lock row 1, column 3 then row 2 columns 2 and 3
0
 
LVL 22

Accepted Solution

by:
Dreamboat earned 500 total points
ID: 17915266
0
Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

 
LVL 44

Author Comment

by:AndyAinscow
ID: 17915300
I'll have to study it.
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 17915333
Sorry...should have said....
You can put form fields into some of those table cells where you want users to have access.
Unfortunately, document protection of ANY section(s) disables lots of formatting, etc. You may be better off looking into VBA Userforms to pop up and enter data for the user into the appropriate areas. Not sure.
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 17915392
It's for report generation.  Currently it is an Access report but there are too many requirements to modify how it looks now - so the thought of automating word and protecting the 'critical' information but allowing the user to modify the less important textual/formatting when required.  (word/line breaks, highlight a phrase....)
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 17915410
ps - I should have said, Word 2003/XP
0
 
LVL 21

Expert Comment

by:Eric Fletcher
ID: 17916066
You could "cover" the parts you want to prevent users from inadvertently changing: insert a small image (a 1x1 pixel white GIF would do) and use Format Picture to place it in front of text, then use the Crop handles to extend the picture corners out over the table you want to cover. Now the table will be visible through the negatively-cropped image, and if a user clicks within it, they will be selecting the picture and not content.

Note that this approach would reduce indadvertent edits but won't stop someone from getting at the content if they really want to.

There may be a way to make the object into a button that would run code to pop up a warning dialog when a user clicked on it but I haven't tried doing that.
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 17916261
Nice thought - it could be worth a try.
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 17916501
Eric - do you know if one can stop the user resizing/deleting the picture.  (I thought that click, delete and the protection is away.  If the user wanted to modify the cell contents then they would first try clicking onto it.)
0
 
LVL 21

Expert Comment

by:Eric Fletcher
ID: 17916769
Not readily... that's why I cautioned that it would only be an alert to a user.

While it would be nice to be able to assume users can actually think before acting, I realize that this is usually only a dream. Dreamboat's suggestion of using forms will offer more protection against changes from users who don't/can't read instructions, but nothing is really completely foolproof IMHO. Of course you can always do a document compare to be able to inspect all differences between an original and what you get back, but that can be a lot of work...

If you could set it up like a button in Excel (so you could attach code to run if it were clicked), you could perhaps prevent them from deleting the image object, but that is beyond my expertise I'm afraid. Perhaps others reading this question could suggest a method? (Or you could post a new question asking for the "how to" more specifically.)
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 17916833
Thanks.
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 17936709
Thanks - using forms should work
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 17948798
Thanks, Andy. :)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

634 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question