Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm running a macro which unprotects a sheet, applies an autofilter, then protects the sheet again with filtering enabled. I'm wondering what the difference is between these 2 snippets, they seem to be equivalent in this instance: with wk .EnableAutoFilter = True .Protect UserInterfaceOnly:=True versus .Protect AllowFiltering:=True Thanks for any insight on this, regards, DaveU |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofilter in protected sheet | Excel Worksheet Functions | |||
Protected Sheet and AutoFilter | Excel Programming | |||
Protected sheet and Autofilter? | Excel Programming | |||
Autofilter protected sheet | Excel Programming | |||
AutoFilter on a Protected sheet | Excel Programming |