| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect cells but not Group function
Does anyone know how to protect a worksheet and still have access to the
"Group" filter functionality? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells but not Group function
Unless you protect the sheet in a special manner, the dropdowns for your
autofilter won't work on that protected worksheet. If you already have the outline/subtotals/autofilter 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 '.EnableOutlining = 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 ====== If you meant Grouping from Data|Group, use .enableoutlining. Please help James wrote: Does anyone know how to protect a worksheet and still have access to the "Group" filter functionality? Thanks! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells but not Group function
Dave, I still get the error message of "You cannot use this command on a
protected sheet"....any suggestions? "Dave Peterson" wrote: Unless you protect the sheet in a special manner, the dropdowns for your autofilter won't work on that protected worksheet. If you already have the outline/subtotals/autofilter 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 '.EnableOutlining = 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 ====== If you meant Grouping from Data|Group, use .enableoutlining. Please help James wrote: Does anyone know how to protect a worksheet and still have access to the "Group" filter functionality? Thanks! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells but not Group function
Did you allow macros to run when you opened the workbook?
Did you change the worksheet name? Did you change the password? Please help James wrote: Dave, I still get the error message of "You cannot use this command on a protected sheet"....any suggestions? "Dave Peterson" wrote: Unless you protect the sheet in a special manner, the dropdowns for your autofilter won't work on that protected worksheet. If you already have the outline/subtotals/autofilter 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 '.EnableOutlining = 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 ====== If you meant Grouping from Data|Group, use .enableoutlining. Please help James wrote: Does anyone know how to protect a worksheet and still have access to the "Group" filter functionality? Thanks! -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells but not Group function
Yes, I allowed macros to run. I changed the worksheet name to match yours
"worksheet1". hmmm, Dave, the code you gave me would allow the "Group & Ouline" function to work with the "protect sheet" function on (so that I can protect cells from being written on)? "Dave Peterson" wrote: Did you allow macros to run when you opened the workbook? Did you change the worksheet name? Did you change the password? Please help James wrote: Dave, I still get the error message of "You cannot use this command on a protected sheet"....any suggestions? "Dave Peterson" wrote: Unless you protect the sheet in a special manner, the dropdowns for your autofilter won't work on that protected worksheet. If you already have the outline/subtotals/autofilter 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 '.EnableOutlining = 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 ====== If you meant Grouping from Data|Group, use .enableoutlining. Please help James wrote: Does anyone know how to protect a worksheet and still have access to the "Group" filter functionality? Thanks! -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells but not Group function
Dave, do you turn on the protection after you enter the code?
"Please help James" wrote: Yes, I allowed macros to run. I changed the worksheet name to match yours "worksheet1". hmmm, Dave, the code you gave me would allow the "Group & Ouline" function to work with the "protect sheet" function on (so that I can protect cells from being written on)? "Dave Peterson" wrote: Did you allow macros to run when you opened the workbook? Did you change the worksheet name? Did you change the password? Please help James wrote: Dave, I still get the error message of "You cannot use this command on a protected sheet"....any suggestions? "Dave Peterson" wrote: Unless you protect the sheet in a special manner, the dropdowns for your autofilter won't work on that protected worksheet. If you already have the outline/subtotals/autofilter 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 '.EnableOutlining = 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 ====== If you meant Grouping from Data|Group, use .enableoutlining. Please help James wrote: Does anyone know how to protect a worksheet and still have access to the "Group" filter functionality? Thanks! -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells but not Group function
I keep trying this and it just isn't working. Can someone break this down
into idiot language for me? "Please help James" wrote: Does anyone know how to protect a worksheet and still have access to the "Group" filter functionality? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| How do I protect sheet, but allow "group" function to work | Excel Discussion (Misc queries) | |||
| Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
| How do I protect cells against only the "Delete" function? | Excel Discussion (Misc queries) | |||
Hybrid Mode
