Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Autofiler Column
How can I Protect a Worksheet that has a autofilter column. I want users to
be able to use the drop down menu in the autofilter column to narrow the selections but I don't want users to have the ability to change anything on the spreadsheet. If I unlock the autofilter column and protect the sheet it doesn't activate the dropdown. Thanks, Mickey |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Autofiler Column
Hi Mickey
In 2002 and up this is a option when you protect your sheet. ToolsProtection...Protect sheet check "Use AutoFilter" But first apply the filter before you protect the sheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mickey" wrote in message ... How can I Protect a Worksheet that has a autofilter column. I want users to be able to use the drop down menu in the autofilter column to narrow the selections but I don't want users to have the ability to change anything on the spreadsheet. If I unlock the autofilter column and protect the sheet it doesn't activate the dropdown. Thanks, Mickey |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Autofiler Column
Mickey
Which version of Excel? In 2002 and 2003 you can protect the worksheet with "Use Autofilter" checked on. You must have the autofilter already enabled before protecting the sheet. Gord Dibben MS Excel MVP On Mon, 5 Feb 2007 12:06:03 -0800, Mickey wrote: How can I Protect a Worksheet that has a autofilter column. I want users to be able to use the drop down menu in the autofilter column to narrow the selections but I don't want users to have the ability to change anything on the spreadsheet. If I unlock the autofilter column and protect the sheet it doesn't activate the dropdown. Thanks, Mickey |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Autofiler Column
I have Excel 2000.
"Ron de Bruin" wrote: Hi Mickey In 2002 and up this is a option when you protect your sheet. ToolsProtection...Protect sheet check "Use AutoFilter" But first apply the filter before you protect the sheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mickey" wrote in message ... How can I Protect a Worksheet that has a autofilter column. I want users to be able to use the drop down menu in the autofilter column to narrow the selections but I don't want users to have the ability to change anything on the spreadsheet. If I unlock the autofilter column and protect the sheet it doesn't activate the dropdown. Thanks, Mickey |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Autofiler Column
Hi Mickey
Then it is possible with code http://www.contextures.com/xlautofilter03.html#Protect -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mickey" wrote in message ... I have Excel 2000. "Ron de Bruin" wrote: Hi Mickey In 2002 and up this is a option when you protect your sheet. ToolsProtection...Protect sheet check "Use AutoFilter" But first apply the filter before you protect the sheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mickey" wrote in message ... How can I Protect a Worksheet that has a autofilter column. I want users to be able to use the drop down menu in the autofilter column to narrow the selections but I don't want users to have the ability to change anything on the spreadsheet. If I unlock the autofilter column and protect the sheet it doesn't activate the dropdown. Thanks, Mickey |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Autofiler Column
Thank you so much. It works great.
"Ron de Bruin" wrote: Hi Mickey Then it is possible with code http://www.contextures.com/xlautofilter03.html#Protect -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mickey" wrote in message ... I have Excel 2000. "Ron de Bruin" wrote: Hi Mickey In 2002 and up this is a option when you protect your sheet. ToolsProtection...Protect sheet check "Use AutoFilter" But first apply the filter before you protect the sheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mickey" wrote in message ... How can I Protect a Worksheet that has a autofilter column. I want users to be able to use the drop down menu in the autofilter column to narrow the selections but I don't want users to have the ability to change anything on the spreadsheet. If I unlock the autofilter column and protect the sheet it doesn't activate the dropdown. Thanks, Mickey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |