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?
|