Activex Text Box Protection

worksheet functions >> Activex Text Box Protection

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
--
Gerry Bakker

Excel151

worksheet functions >> Activex Text Box Protection 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.

--
Gerry Bakker

> 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
> --
> Gerry Bakker