Protecting cells with data validation

C

cottage6

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lock Range of Cells 1
VB to protect cells not working in Excel 2003? 3
Protect a sheet 3
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? 2
Code to format cells on several worksheets 2
How to extend the life of a variable from one Private Sub routine to another? 2
Use VB to unlock & lock cell protection 2
Pasting a cell into bookmarked table from excel vba 1

Top