| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unprotect Auto Filters
Hi...
I need a sheet fully protected but need the user to have access to the Auto Filters...how can I do this. Simple but beyond me! grateful for any help... Gordon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unprotect Auto Filters
Good afternoon Graham If you are using Excel 2002 or later you can specify when protecting the sheet whether filters can be acivated or not. If you have Excel 97/2000 then Debra Dalgleish has an elegant solution to this on her site: http://www.contextures.com/xlautofilter03.html#Protect HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=480096 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use "OR" in two auto-filters/custom filters? | Excel Discussion (Misc queries) | |||
| Auto Filters | Excel Worksheet Functions | |||
| List with auto filters | Excel Worksheet Functions | |||
| How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions | |||
| auto filters | Excel Discussion (Misc queries) | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
