AutoFilter Macro Protected Sheet

[JMC]

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?

 

[ryguy7272]

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---