Hello,
Can You help me ?
How I can setup permanent value of some field on form in Excel even if I am writing this value during loaded this form ?
Printable View
Hello,
Can You help me ?
How I can setup permanent value of some field on form in Excel even if I am writing this value during loaded this form ?
If you mean a userform, and you want the display of a text box to always be the same, set the Locked property of the textbox to true.
If you mean a spreadsheet cell, I guess its protect sheet options, but you'd have to read up on that.
Vince
Sorry,
I started to think tu use this filed like to enter licence number.
If this field fill be empty the form will be not running.