Working with protection
 

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

Working with protection
 

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

Working with protection
 

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