Excel cell protection

M

mbithi_nick

I have been trying to no avail to protect cells in a sheet so as to avoid any
unauthorised editing. The feature which is in the program for locking cells
does not help at all. So I was wondering does it mean that after coming up
with such a wonderful program, the developers of Ms-Excel were unable to come
up with a way of effectively locking cells in a work sheet. This has really
surprised me. I am using Ms-Excel 2003.

I hope someone will respond to this issue.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...c932&dg=microsoft.public.office.developer.vba
 
C

Chip Pearson

If you choose Protect Sheet from the Tools menu, cells whose
Locked property is True (the default) will be locked from
edititing. What particular problem are you having?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top