View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MDW MDW is offline
external usenet poster
 
Posts: 117
Default Protect Worksheet While Allowing Autofilter

I've got an Excel file that will be used by people using both Excel 2000 and
Excel 2003. At various points, I have VBA code that protects and unprotects
various sheets. However, these sheets have the AutoFilter option turned on,
and I find that in certain versions, the filters won't work as the sheets
are/aren't protected.

I know that in XL2003 the .Protect method actually allows you to enable
autofiltering, but that is not supported in XL2000.

Is there some other way I can do this?
--
Hmm...they have the Internet on COMPUTERS now!