Activex Text Box Protection  
Author Message
tgmcmillen





PostPosted: Sun Nov 06 18:33:43 CST 2005 Top

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

Excel451  
 
 
GerryBakker





PostPosted: Sun Nov 06 18:33:43 CST 2005 Top

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