Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter global Show All function disabled in protected worksheet
Hi everyone. I’m hoping that someone has an answer for this problem. M
company is using a large shared spreadsheet under Excel 2002 where it i necessary to constantly use the Auto filter function. The Auto filte function is in many instances used once, then used again – cascad style to sub filter data - so on and so forth. My company of late ha requested this spreadsheet to be protected. Although Excel 2002 allow you to turn on the Auto filter functionality, it still disables th global “Show All” function under filter in the toobar. It only allow an individual Auto filtered column at a time to be unfiltered. Unfortunately, most users want to use the global show all functio rather than individually unfiltering each column. I wrote a smal macro that temporarily unprotects the spreadsheet, restores the for using the global Show All then reprotects the form. This worked fin until I shared the workbook. Unfortunately, you can’t unprotect a Excel workbook while it is shared (as far as I know) and as such, th macro fails! Does any one have any ideas how I can restore the Globa Show All function in a protected worksheet or some other way around th problem? Thank -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is autofilter & sort disabled in protected cells? | Excel Worksheet Functions | |||
AUTOFILTER IN A PROTECTED WORKSHEET | Excel Discussion (Misc queries) | |||
Autofilter set to "SHOW ALL" on open for a protected worksheet | Excel Discussion (Misc queries) | |||
Using Autofilter on a Protected Worksheet | Excel Discussion (Misc queries) | |||
enable autofilter in a protected worksheet in Excel 97 | Excel Worksheet Functions |