Autofilter global Show All function disabled in protected worksheet

F

Fartnuckles

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
 
T

Tom Ogilvy

I don't know if this will overcome the sharing limitation (don't have xl2002
handy), but have you tried

Activeworkbook.Protect Password:="ABC", UserInterfaceOnly:=True
' showall code
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top