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


"Gerry Bakker" wrote:

> 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