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?