Protected Shared workbook with autofiltering

  • Thread starter Thread starter Iain King
  • Start date Start date
I

Iain King

I want to have my workbook both protected and shared, whilst still leaving
autofiltering turned on. The workbook runs fine without sharing it : at
startup it calls a macro which:

..EnableAutoFilter = True
..Protect DrawingObjects:=True, _
contents:=True, Scenarios:=True, UserInterfaceOnly:=True


for all relevant sheets. The important part is UserInterfaceOnly:=True,
which if set allows autofiltering to (A) work, and (B) be controlled by
code. Which is all great until I share the book - in a shared workbook you
cannot call .Protect

Now, you should simply be able to set your protection level before sharing.
Unfortunately, and for some unknown reason, Excel kills
UserInterfaceOnly:=True whenever it saves the file. The code above was
called upon workbook_open. I can't leave that event in however, since it
doesn't work in a shared workbook.

This topic has been posted before, but it's been a while. I'm basically
wondering if this problem, which is basically a bug in Excel, has been fixed
yet? And if so, in what version?

Iain King
 
xl2002 added a bunch of options to the Tools|protection|protect sheet including
one to protect the worksheet, but allow an existing autofilter to keep working.

And this works on a protected worksheet in a shared workbook.
 
Back
Top