General discussion

Locked

individual cell protection issues in Exc

By Wayne ·
We use spreadsheets that need certain areas protected from users entering or corrupting data. However, built into these sheets (in the Headers at the top) are some filtered, selectable lists and small macro applications. If we turn on protection to the sheet, these cease to function. (they become unselectable). Trying to select and lock the sheet by individual cells also has the same results. (MS Knowledgebase Doc Q100618 & Q100936)

Any help/ideas would be appreciated!!

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

individual cell protection issues in Exc

by Al Hedstrom In reply to individual cell protectio ...

I am unaware of a method to do as you specifically ask. One possible work-around is to Protect and Share the file with a password (Tools menu | Protect | Protect and Share Workbook). That way only those users with the password can modify.

I'mnot sure, however, that meets your needs.

Al Hedstrom

Collapse -

individual cell protection issues in Exc

by Wayne In reply to individual cell protectio ...
Collapse -

individual cell protection issues in Exc

by Wayne In reply to individual cell protectio ...
Collapse -

individual cell protection issues in Exc

by mbazzell In reply to individual cell protectio ...

I have run into the same problem. I built the protect and unprotect into my macro as a work around. I created my document and protected it, but when I built my macro the first thing I had it do was unprotect the sheet and the last thing I had it do was protect it again. I hope this helps!

Collapse -

individual cell protection issues in Exc

by Wayne In reply to individual cell protectio ...
Collapse -

individual cell protection issues in Exc

by Wayne In reply to individual cell protectio ...
Back to Software Forum
6 total posts (Page 1 of 1)  

Software Forums