Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Worksheet While Allowing Autofilter
I've got an Excel file that will be used by people using both Excel 2000 and
Excel 2003. At various points, I have VBA code that protects and unprotects various sheets. However, these sheets have the AutoFilter option turned on, and I find that in certain versions, the filters won't work as the sheets are/aren't protected. I know that in XL2003 the .Protect method actually allows you to enable autofiltering, but that is not supported in XL2000. Is there some other way I can do this? -- Hmm...they have the Internet on COMPUTERS now! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Worksheet While Allowing Autofilter
You can modify your code that protects the worksheet:
With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True '.EnableOutlining = True .EnableAutoFilter = True End With (assumes that data|filter has already been applied) MDW wrote: I've got an Excel file that will be used by people using both Excel 2000 and Excel 2003. At various points, I have VBA code that protects and unprotects various sheets. However, these sheets have the AutoFilter option turned on, and I find that in certain versions, the filters won't work as the sheets are/aren't protected. I know that in XL2003 the .Protect method actually allows you to enable autofiltering, but that is not supported in XL2000. Is there some other way I can do this? -- Hmm...they have the Internet on COMPUTERS now! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Protect Function, while allowing macros | Excel Worksheet Functions | |||
How do I protect a number of sheets allowing the user to add a com | New Users to Excel | |||
To Protect Excel documents and allowing only few cells to edit | Excel Worksheet Functions | |||
Autofilter - allowing for error | Excel Programming | |||
Protect sheets from editing but allowing macro to do so? | Excel Programming |