locking labels in excell XP

[Greycon]

I have a excell spreadsheet with labels in it.

The users are able to change the label text, even though
it is locked, the worksheet is looked, and the workbook is
locked. I disabled the labels, and they can not change
them. But I don't like how it changes the lettering to
grey.

How can I lock down a label, so all they can do is look at
it, and not have to disable it?

Any thoughts would be helpfull,

Greycon

 

[SkipVought]

Hi,

You must PROTECT the sheet for the LOCKED elements to be locked.

Tools/Protection/Protect Sheet...

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[Greycon]

Skip,

thank you for the reply,

I thought I did that.

Should this not do it?

Sheets("Inventory ZB").Protect ("ABC_Weekly"), userinterfaceonly:=True

They do need to enter information into the unlocked cells.

Thank You again,

Greycon

 

[SkipVought]

1. You never said that you PROTECTED the sheet -- only LOCKED.

2. "They do need to enter information into the unlocked cells." That's exactly what can be done when a sheet is protected -- enter data in unlocked cells.
[tt]
expression.Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)
[/tt]
Maybe you ought to include DrawingObjects



Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[Greycon]

Skip,

Sorry for the missing information.

Yes I have locked and protected the workbook, and sheets and Macros.

I will try including drawingobjects in the command tomorrow.

I probely should have put this question in the VBA forum.
But I did not know if it was a VBA issue, or a sheet issue.

Thank you once again,

Greycon