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
--
Lee Kirts

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.

--
Regards,
Tom Ogilvy

"Lee" wrote in message
...
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
--
Lee Kirts

Tom,

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

Lee


"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"Lee" wrote in message
...
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
--
Lee Kirts