How do I make a text box accessible in a protected Excel sheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JWarnick-SHH - 15 Mar 2006 21:18 GMT

I inserted check boxes into my worksheet using the Forms toolbar. These
appear in text boxes and I have them linked to certain cells. The worksheet
is setup so that certain cell ranges can only be accessed by certain users
based off their network logon. The cells that the check boxes are linked to
are included in these ranges, but once I protect the worksheet it doesn't let
them activate the check boxes.

Reply to this Message

SteveG - 15 Mar 2006 21:55 GMT

When you protect the sheet, from the list of options that are allowe
for editing be sure to check Edit Objects. That will allow users t
activate the check boxes.

HTH

Stev

Reply to this Message

JWarnick-SHH - 15 Mar 2006 22:16 GMT

I do have that selected, but it's still not working. Any other suggestions?

Reply to this Message

SteveG - 15 Mar 2006 22:41 GMT

And the linked cells for those check boxes are part of the range o
cells that the designated users are able to edit? Are you having on
of those users test it or are you testing it yourself? I believe tha
if you did not include yourself in the list of users that are able t
edit those cells, it won't allow you to edit them once the sheet i
protected. Otherwise, I am not sure what it could be. I am sur
someone in this group can offer up other suggestions though.

HTH
Stev

Reply to this Message

JWarnick-SHH - 15 Mar 2006 22:55 GMT

Yes to all the above. I've tried changing the protection on the check boxes,
I've tried sending them to the front...I've tried everything I can logically
think of with no luck. It's driving me nuts!

Reply to this Message

SteveG - 16 Mar 2006 14:53 GMT

Sorry I couldn't offer any more suggestions. I created a test workboo
following your example and then had one of my designated users edit th
check boxes from their computer without an issue.

One thing I did notice was that when I set the password to edit,
selected Deny if the user did not provide the password. The only issu
with doing that is if the user is a member of more than one group an
their permissions in the other group are set to Deny for that rang
then the Deny takes precedence over the Allow which would not allo
that user to edit the range. Could that be the issue?

Stev

Reply to this Message