Software·43,996 discussions

individual cell protection issues in Exc

Locked

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!!

Topic

individual cell protection issues in Exc

In reply to individual cell protection issues in Exc

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

individual cell protection issues in Exc

In reply to individual cell protection issues in Exc

individual cell protection issues in Exc

In reply to individual cell protection issues in Exc

individual cell protection issues in Exc

In reply to individual cell protection issues in Exc

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!

individual cell protection issues in Exc

In reply to individual cell protection issues in Exc

individual cell protection issues in Exc

In reply to individual cell protection issues in Exc

[Author]

Replies