| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with using Auto-filter in a protected Worksheet.
I am try to figure out a way to use Auto-filter when some of the cells in a
worksheets are protected. I don't want users to be able to change the data in the sheet but they need to be able to use Auto-filter in order to do some of their work. The problem is, anytime we protect the sheet, they can't use Auto-filter. Is there a work around for this? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with using Auto-filter in a protected Worksheet.
Hi,
You could try checking the 'Use Autofilter' option when you protect the sheet. Mike "Ayo" wrote: I am try to figure out a way to use Auto-filter when some of the cells in a worksheets are protected. I don't want users to be able to change the data in the sheet but they need to be able to use Auto-filter in order to do some of their work. The problem is, anytime we protect the sheet, they can't use Auto-filter. Is there a work around for this? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with using Auto-filter in a protected Worksheet.
Thanks Mike. That works.
"Mike H" wrote: Hi, You could try checking the 'Use Autofilter' option when you protect the sheet. Mike "Ayo" wrote: I am try to figure out a way to use Auto-filter when some of the cells in a worksheets are protected. I don't want users to be able to change the data in the sheet but they need to be able to use Auto-filter in order to do some of their work. The problem is, anytime we protect the sheet, they can't use Auto-filter. Is there a work around for this? Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with using Auto-filter in a protected Worksheet.
Hey Mike,
I just tried it with another file and it isn't working on that file. What could be the problem? "Mike H" wrote: Hi, You could try checking the 'Use Autofilter' option when you protect the sheet. Mike "Ayo" wrote: I am try to figure out a way to use Auto-filter when some of the cells in a worksheets are protected. I don't want users to be able to change the data in the sheet but they need to be able to use Auto-filter in order to do some of their work. The problem is, anytime we protect the sheet, they can't use Auto-filter. Is there a work around for this? Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with using Auto-filter in a protected Worksheet.
Ayo
Data Filter must be enabled on a range before you protect the sheet with the "Use Autofilter" checked. i.e. select a range and DataFilterAutofilter to get the arrows. Now protect the sheet. Gord Dibben MS Excel MVP On Mon, 29 Oct 2007 07:31:01 -0700, Ayo wrote: Hey Mike, I just tried it with another file and it isn't working on that file. What could be the problem? "Mike H" wrote: Hi, You could try checking the 'Use Autofilter' option when you protect the sheet. Mike "Ayo" wrote: I am try to figure out a way to use Auto-filter when some of the cells in a worksheets are protected. I don't want users to be able to change the data in the sheet but they need to be able to use Auto-filter in order to do some of their work. The problem is, anytime we protect the sheet, they can't use Auto-filter. Is there a work around for this? Thank you. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with using Auto-filter in a protected Worksheet.
Thanks Gord.
"Gord Dibben" wrote: Ayo Data Filter must be enabled on a range before you protect the sheet with the "Use Autofilter" checked. i.e. select a range and DataFilterAutofilter to get the arrows. Now protect the sheet. Gord Dibben MS Excel MVP On Mon, 29 Oct 2007 07:31:01 -0700, Ayo wrote: Hey Mike, I just tried it with another file and it isn't working on that file. What could be the problem? "Mike H" wrote: Hi, You could try checking the 'Use Autofilter' option when you protect the sheet. Mike "Ayo" wrote: I am try to figure out a way to use Auto-filter when some of the cells in a worksheets are protected. I don't want users to be able to change the data in the sheet but they need to be able to use Auto-filter in order to do some of their work. The problem is, anytime we protect the sheet, they can't use Auto-filter. Is there a work around for this? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List auto-expansion with protected worksheet | Excel Discussion (Misc queries) | |||
| Using Hide, Unhide, and auto filter - select all on a protected sh | Excel Worksheet Functions | |||
| How do I enable auto-expanding lists in a protected worksheet? | Excel Discussion (Misc queries) | |||
| Auto Filter with Protected Worksheet | Excel Worksheet Functions | |||
| Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Linear Mode
