View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JSSuggs JSSuggs is offline
external usenet poster
 
Posts: 1
Default Using autofilter and saving changes

I have an auto filter on my worksheet and it also uses hyperlinks. Each time
I filter and then click on the hyperlink it asks do I wish to save my
changes. Is there a way to stop this question from being asked? I have tried
saving as a read only document and password protecting changes but the only
way that works is to remove the filter. Does anyone have any other
suggestions?
--
Jennifer S. Suggs
BCD Travel