Activex Text Box Protection

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top