View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
William William is offline
external usenet poster
 
Posts: 119
Default AUTOFILTER IN A PROTECTED WORKSHEET

I have a spreadsheet that has some colomns comprised completely of locked
cells, with the exception of the header column. Other columns have no locked
cells. However, after I protect the worksheet, the autofilter option is
greyed out for ALL the columns. I was hoping there was a way to be able to
autofilter the columns that have no locked cells while the worksheet is
protected. Is this possible?
--
William