Labels in a user form

[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.

 

[Tom Ogilvy]

Doesn't sound like a label.

Are you sure?

 

[Felix Rode]

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

 

[Tom Ogilvy]

The subject is "Labels in a user form"

he says:

The user form has a label "Amend contact information"

???

 

[John Stout]

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

 

[Tom Ogilvy]

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