Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using AutoFilter with worksheet protection in 2000 vs. 2003
I have created an Autofilter on 2 columns of a protected worksheet in 2000
using a macro that runs upon opening of the worksheet. I am encountering a problem when a 2003 user tries to open the worksheet but cannot use the AutoFilter dropdowns. I know that in 2003 it is much easier to use the Autofilter on a protected worksheet with the AutoFilter option. Anyone have any ideas how I can create the AutoFilter/Protected worksheet situation that will work no matter what Excel version is being used? |
#2
|
|||
|
|||
When I run this code from Workbook_Open in either Excel 2000 or 2003 auto
filtering seems to work okay on the protected sheet: Sub ProtectSheet() With Sheet1 .EnableAutoFilter = True .Protect , True, True, True, True End With End Sub -- Jim "gncook" wrote in message ... |I have created an Autofilter on 2 columns of a protected worksheet in 2000 | using a macro that runs upon opening of the worksheet. I am encountering a | problem when a 2003 user tries to open the worksheet but cannot use the | AutoFilter dropdowns. I know that in 2003 it is much easier to use the | Autofilter on a protected worksheet with the AutoFilter option. Anyone have | any ideas how I can create the AutoFilter/Protected worksheet situation that | will work no matter what Excel version is being used? |
#3
|
|||
|
|||
If you already have the outline applied, you can protect the worksheet in code
(auto_open/workbook_open??). Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableAutoFilter = True End With End Sub It needs to be reset each time you open the workbook. (excel doesn't remember it after closing the workbook.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm gncook wrote: I have created an Autofilter on 2 columns of a protected worksheet in 2000 using a macro that runs upon opening of the worksheet. I am encountering a problem when a 2003 user tries to open the worksheet but cannot use the AutoFilter dropdowns. I know that in 2003 it is much easier to use the Autofilter on a protected worksheet with the AutoFilter option. Anyone have any ideas how I can create the AutoFilter/Protected worksheet situation that will work no matter what Excel version is being used? -- Dave Peterson |
#4
|
|||
|
|||
Thanks Dave! This worked fine.
"Dave Peterson" wrote: If you already have the outline applied, you can protect the worksheet in code (auto_open/workbook_open??). Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableAutoFilter = True End With End Sub It needs to be reset each time you open the workbook. (excel doesn't remember it after closing the workbook.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm gncook wrote: I have created an Autofilter on 2 columns of a protected worksheet in 2000 using a macro that runs upon opening of the worksheet. I am encountering a problem when a 2003 user tries to open the worksheet but cannot use the AutoFilter dropdowns. I know that in 2003 it is much easier to use the Autofilter on a protected worksheet with the AutoFilter option. Anyone have any ideas how I can create the AutoFilter/Protected worksheet situation that will work no matter what Excel version is being used? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfering a hyperlink from an autofilter drop down to a different worksheet | Excel Discussion (Misc queries) | |||
worksheet protection | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Worksheet Protection and Inserting Pictures | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |