Activex Text Box Protection

G

Guest

I am trying to protect the contents of an Activex text box. Can someone tell
me the correct settings please. The text box is linked to its source cell,
in the properties Locked = True, the sheet is protected. The only time the
text box contents cannot be selected is when design mode is on and sheet
protected. The next time the file is opened, design mode is off, and you can
select/change the text box contents (not reflected in the source cell).

Your help appreciated, thanks
 
G

Guest

A solution I have found for this problem is to create an event procedure for
the Workbook_Open event where I turn Design Mode on. This seems to work OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell color in protected sheet 1
Allow user to change the state of ("click" in) check-boxes on protected worksheets? 2
Unlocking "check box" control function 1
protecting a text box in spreadshhet 2
I can still select & manipulate locked & protected cells in '07 1
Copy and move check box (check boxes) with new cell link? 1
Link text box to a cell 1
Insert/ delete row in protected worksheet 7

Top