View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lee lee is offline
external usenet poster
 
Posts: 184
Default 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