| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextBox lock
How do I stop anyone from changing values or text in a textbox?
The textbox in question is linked to a cell and I dont want anyone able to click on it and change the value or text. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TextBox lock
Set the 'Enabled' property to FALSE
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Pas" wrote: How do I stop anyone from changing values or text in a textbox? The textbox in question is linked to a cell and I dont want anyone able to click on it and change the value or text. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TextBox lock
Many thanks it works
"Gary Brown" wrote: Set the 'Enabled' property to FALSE -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Pas" wrote: How do I stop anyone from changing values or text in a textbox? The textbox in question is linked to a cell and I dont want anyone able to click on it and change the value or text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
| Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
| Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
| how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
| How can I lock the position of a textbox? | Excel Discussion (Misc queries) | |||
Linear Mode
