Labels in a user form

  • Thread starter Thread starter John Stout
  • Start date Start date
J

John Stout

I'm using Excel 97.

I have a user form which enables the user to amend contact information
about people.The user form has a label "Amend contact information"
(surprisingly enough).

When the form is displayed however, the user can click on the label
and change it. I don't want this. How can I prevent it?

Many thanks.
 
Believe John is talking about the sheet name (i.e. sheet 1).
John,
did you think about protecting (tools>>protection) the sheet and
workbook and unprotect only the ranges (select range then
format>>cells>>protection) you want the user to write too. Felix
 
It is a label in a user form. I created it using the label icon on the
toolbox and when I select it in visual basic, the properties window
has named it "Label9 Label".

Originally I had used a text box then I read on a thread that a label
was more appropriate.

When I emailed the spreadsheet to the office, where we use Excel 2002,
the problem goes away. Could this be something unique to Excel 97?

Many thanks.

John Stout
 
I was testing in excel 97 SR2. No problem - couldn't edit the label by
clicking on it.
 
Back
Top