Protect cells but not Group function
 

Does anyone know how to protect a worksheet and still have access to the
"Group" filter functionality? Thanks!

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

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

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

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

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

Protect cells but not Group function
 

Dave, do you enter this code in VB sheet1?

"Please help James" wrote:

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

Protect cells but not Group function
 

This code goes in a general module--not behind thisworkbook or behind a
worksheet.

Then save the file, close it and reopen it.

In fact and another line to the top of the routine:

msgbox "Made it here!"

Then if you see that msgbox, you'll know you put the code in the correct spot.
(Remove that line when you have it working.)

Please help James wrote:

Dave, do you enter this code in VB sheet1?

"Please help James" wrote:

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


--

Dave Peterson

Protect cells but not Group function
 

Thank You Dave! It finally worked!

"Dave Peterson" wrote:

This code goes in a general module--not behind thisworkbook or behind a
worksheet.

Then save the file, close it and reopen it.

In fact and another line to the top of the routine:

msgbox "Made it here!"

Then if you see that msgbox, you'll know you put the code in the correct spot.
(Remove that line when you have it working.)

Please help James wrote:

Dave, do you enter this code in VB sheet1?

"Please help James" wrote:

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


--

Dave Peterson

Protect cells but not Group function
 

Woohoo!

Glad you got it working.

Please help James wrote:

Thank You Dave! It finally worked!

"Dave Peterson" wrote:

This code goes in a general module--not behind thisworkbook or behind a
worksheet.

Then save the file, close it and reopen it.

In fact and another line to the top of the routine:

msgbox "Made it here!"

Then if you see that msgbox, you'll know you put the code in the correct spot.
(Remove that line when you have it working.)

Please help James wrote:

Dave, do you enter this code in VB sheet1?

"Please help James" wrote:

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


--

Dave Peterson


--

Dave Peterson

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!