Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working with worksheet protection | Excel Worksheet Functions | |||
Worksheet Protection not Working | Excel Discussion (Misc queries) | |||
Protection with working dropdown lists. | Excel Discussion (Misc queries) | |||
Working in a Worksheet that has protection on | Excel Worksheet Functions | |||
Protection is working sparadically | Excel Discussion (Misc queries) |