View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo Ann Jo Ann is offline
external usenet poster
 
Posts: 1
Default Combined use - drop-downs, filters, protect sheet

Want to protect columns A & B (year & report number being taken by user)
Have Drop-downs (w/ values on separate sheet) in Columns C, F, G, H
Also want to protect data that's entered in all columns (except A & B). Once
data is entered & user exits file, can that data be protected? Want to do
this so that with multiple users, one cannot inadvertently change the data.
All users are on a PC platform w/ possibly 2 different operating systems. I
have Windows XP and using Excel 2003