Protecting cells in a shared workbook using autofilters

[STEFAN BEAN]

I created a shared workbook for others to make changes to. I have created
an autofilter and have my coworkers only make changes to data under their
name.

How can I prevent my coworkers from access the other information in the
shared workbook? Stuff that they are not suppose to change.

In other words can I protect certain cells while autofilter is on?

-Stef

 

[Dave Peterson]

If the workbook were not shared, then you could protect the worksheet (using
VBA) and allow the users to have access to the filters. And this code would
have to protect the worksheet each time the workbook opened.

But once you share the workbook, you can't change the protection of a
worksheet. So it's a catch 22.

The only way I know around this is to upgrade to xl2002. It has an option under
Tools|protection|protect sheet that allows users to use autofilters. And xl2002
will respect that with no additional code.

But that doesn't help if you're running xl2k or earlier.