Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text to appear at top of cell | New Users to Excel | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
ActiveX Controls Display Issue? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |