View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meltad Meltad is offline
external usenet poster
 
Posts: 98
Default Can I protect/lock columns AND set custom views?

I've got a worksheet with about 70 columns and have created 6 different
custom views. I now need to protect certain columns (ideally this would be
different columns for each view) but the views dont work once I've protected
the sheet. Is there a way around this? Can I apply data validation to the
cells to prevent any changes being made to certain coloumns?