AutoFilter Macro Protected Sheet

J

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

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