Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I need to protect 3 cells that use data validation lists to let the user select a choice. One group of people will be allowed to make the selections, while the other group should not be able to make any changes in those 3 cells. I thought the code was relatively simple; it works fine in Excel XP and changes can't be made. However, when I try it in Excel 2000, there is no restriction on those cells. I need to make sure everything works in both versions. Any ideas? Thanks! Range("C2").Select Selection.Locked = True Range("C4").Select Selection.Locked = True Range("J2").Select Selection.Locked = True ActiveSheet.Protect Password:="vendorprotect", DrawingObjects:=True, Contents:=True, Scenarios:=True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Protecting cells but maintaing data groups | Excel Discussion (Misc queries) | |||
Protecting Validated cells from pasting over data | Excel Discussion (Misc queries) | |||
Protecting Data Validation from being overwritten | Excel Programming | |||
Protecting data rather than certain cells | Excel Programming |