Unprotect for adding content within a Text Box

Bright01
Bright01 used Ask the Experts™
on
EE Pros,

QQ.  If I have a Text Box that I'm putting data into, and I protect the Worksheet, does the Text box also become protected like a protected cell or is it always "unprotected"?  If so, and I protect the WS, when I tab to Unlocked cells (assuming that's the only unrestricted cell allowed for), will I be able to tab directly into the Text Box (assuming it is not locked)?

B.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
While protecting the worksheet if you check the box next to Edit Objects under the allowed events, that will allow a user to edit the text content of the checkbox even if the sheet is protected.

Author

Commented:
Got it!  Thank you!

B.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial