Discussion Locked

individual cell protection issues in Exc

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

6 replies

by al hedstrom

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

by mbazzell

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!

This discussion is closed to new replies.