LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default Protecting cells with data validation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom data validation on cells with data validation values AKrobbins Excel Worksheet Functions 2 June 21st 11 04:20 PM
Protecting cells but maintaing data groups DannyS Excel Discussion (Misc queries) 2 January 12th 07 12:21 PM
Protecting Validated cells from pasting over data Pendelfin Excel Discussion (Misc queries) 0 November 15th 06 02:41 PM
Protecting Data Validation from being overwritten Casey[_7_] Excel Programming 0 April 7th 04 04:48 PM
Protecting data rather than certain cells mika. Excel Programming 2 September 9th 03 03:44 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"