AutoFilter Macro Protected Sheet
 

Excel 2003: I am unprotecting/reprotecting an active sheet using a macro.
After running the macro the autofilter gets turned off. The autofilter is
not embedded in the macro. I tried to code: ActiveSheet.EnableAutoFilter
= True
but that does not seem to work. Any suggestions?

AutoFilter Macro Protected Sheet
 

Just turn on the macro recorder, apply the filter as you need it, and turn
off the macro recorder. Go look at the code that you just recorded.
Copy/paste the relevant part to the end of your existing macro, to the spot
right after you reapply the protection.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"JMC" wrote:

Excel 2003: I am unprotecting/reprotecting an active sheet using a macro.
After running the macro the autofilter gets turned off. The autofilter is
not embedded in the macro. I tried to code: ActiveSheet.EnableAutoFilter
= True
but that does not seem to work. Any suggestions?