Posted to microsoft.public.excel.programming

external usenet poster

Posts: 14

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use autofilter with macro in a protected sheet	Minos	Excel Discussion (Misc queries)	1	August 4th 09 03:44 PM
Autofilter in protected sheet	Javier	Excel Worksheet Functions	5	March 24th 08 05:56 PM
Protected sheet and Autofilter?	harpscardiff[_19_]	Excel Programming	4	January 25th 06 05:58 PM
Autofilter protected sheet	vecia[_4_]	Excel Programming	4	September 10th 05 08:25 AM
AutoFilter on a Protected sheet	Olle[_2_]	Excel Programming	1	June 15th 04 08:12 AM

All times are GMT +1. The time now is 07:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us