View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Laura
 
Posts: n/a
Default Auto filter is greyed out


Laura wrote:

By the way, my work book is not protected (it seems) and also I dont
have more than one sheet selected (it seems)


Hello, to anyone that is intersted, I worked out the answer

I managed to reinstate my auto filter by going to tools/options/view
and selected to view all objects. Who knows why it was turned off, but
nevermind, it works now!