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.

Doesn't sound like a label.

Are you sure?

--
Regards,
Tom Ogilvy

John Stout wrote in message
om...
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 (toolsprotection) the sheet and
workbook and unprotect only the ranges (select range then
formatcellsprotection) you want the user to write too. Felix

"Tom Ogilvy" wrote in
:

Doesn't sound like a label.

The subject is "Labels in a user form"

he says:

The user form has a label "Amend contact information"

???
--
Regards,
Tom Ogilvy



Felix Rode wrote in message
8.16...
Believe John is talking about the sheet name (i.e. sheet 1).
John,
did you think about protecting (toolsprotection) the sheet and
workbook and unprotect only the ranges (select range then
formatcellsprotection) you want the user to write too. Felix

"Tom Ogilvy" wrote in
:

Doesn't sound like a label.

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" wrote in message ...
The subject is "Labels in a user form"

he says:

The user form has a label "Amend contact information"

???
--
Regards,
Tom Ogilvy



Felix Rode wrote in message
8.16...
Believe John is talking about the sheet name (i.e. sheet 1).
John,
did you think about protecting (toolsprotection) the sheet and
workbook and unprotect only the ranges (select range then
formatcellsprotection) you want the user to write too. Felix

"Tom Ogilvy" wrote in
:

Doesn't sound like a label.

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

--
Regards,
Tom Ogilvy

"John Stout" wrote in message
om...
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" wrote in message
...
The subject is "Labels in a user form"

he says:

The user form has a label "Amend contact information"

???
--
Regards,
Tom Ogilvy



Felix Rode wrote in message
8.16...
Believe John is talking about the sheet name (i.e. sheet 1).
John,
did you think about protecting (toolsprotection) the sheet and
workbook and unprotect only the ranges (select range then
formatcellsprotection) you want the user to write too. Felix

"Tom Ogilvy" wrote in
:

Doesn't sound like a label.