AutoFilter Macro Protected Sheet

  • Thread starter Thread starter JMC
  • Start date Start date
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?
 
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---
 
Back
Top