Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use autofilter with macro in a protected sheet | Excel Discussion (Misc queries) | |||
Autofilter in protected sheet | Excel Worksheet Functions | |||
Protected sheet and Autofilter? | Excel Programming | |||
Autofilter protected sheet | Excel Programming | |||
AutoFilter on a Protected sheet | Excel Programming |