ExcelBanter - TextBox lock

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - TextBox lock (https://www.excelbanter.com/excel-discussion-misc-queries/262383-textbox-lock.html)

PAS

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.

Gary Brown[_6_]

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.

PAS

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.

All times are GMT +1. The time now is 09:36 PM.