Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I enable autofilter on a protected shared workbook?
How do I do this in Excel 2000? I can get autofilter working in a protected
sheet using a vbr code, but can't get this autofilter working in a protected shared workbook. Anyone know how to resolve this? |
#2
|
|||
|
|||
The bad news is that you want to change the protection of a worksheet with
something like: With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableAutoFilter = True End With But you can't change worksheet protection in a shared workbook. I think you'll have to make a choice--shared or filters. Bungle wrote: How do I do this in Excel 2000? I can get autofilter working in a protected sheet using a vbr code, but can't get this autofilter working in a protected shared workbook. Anyone know how to resolve this? -- Dave Peterson |
#3
|
|||
|
|||
Cheers Dave,
I kind of thought that that may be the case. It does seem a little stupid though doesn't it?! "Dave Peterson" wrote: The bad news is that you want to change the protection of a worksheet with something like: With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableAutoFilter = True End With But you can't change worksheet protection in a shared workbook. I think you'll have to make a choice--shared or filters. Bungle wrote: How do I do this in Excel 2000? I can get autofilter working in a protected sheet using a vbr code, but can't get this autofilter working in a protected shared workbook. Anyone know how to resolve this? -- Dave Peterson |
#4
|
|||
|
|||
There are a lot of features that are disabled with shared workbooks.
I'm not sure if anyone (outside of MS) actually knows why they didn't choose to enable some. Bungle wrote: Cheers Dave, I kind of thought that that may be the case. It does seem a little stupid though doesn't it?! "Dave Peterson" wrote: The bad news is that you want to change the protection of a worksheet with something like: With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableAutoFilter = True End With But you can't change worksheet protection in a shared workbook. I think you'll have to make a choice--shared or filters. Bungle wrote: How do I do this in Excel 2000? I can get autofilter working in a protected sheet using a vbr code, but can't get this autofilter working in a protected shared workbook. Anyone know how to resolve this? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter in protected sheet | Excel Worksheet Functions | |||
Autofilter on protected work book? | Excel Discussion (Misc queries) | |||
enable autofilter in a protected worksheet in Excel 97 | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Filtering a protected WS in a shared workbook - Excel 2000 | Excel Discussion (Misc queries) |