Working with protection

[Guest]

I want to let users enter data into cells on a protected worksheet. Is there
a way to set the protection which allows all cell formatting except word
wrap? In other words, can I set the protection to select only specific
elements of the formatting modules.

What I'm doing now:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True _
, AllowFormattingCells:=True, AllowFiltering:=True, Password:="xyz"

Thanks,

Lee

 

[Tom Ogilvy]

What you see is what you get.

Maybe on every selection change you can have code roll through your workbook
and correct any liberties taken by your users.

 

[Guest]

Tom,

Thanks! I was afraid that was the answer since I couldn't find references
to it anywhere I looked.

Lee