Just to add to OssieMac's response.

This option to allow autofilter in worksheet protection was added in xl2002.

Before that version, there is no way to use autofilter on protected sheets in
shared workbooks (shared means tools|Share workbook, right?)


OssieMac wrote:

By filters, I assume that you mean AutoFilter. In Protection there is an
option to allow users to use autofilter.

Do you want a macro to run on opening the workbook to activate the
particular worksheet and cell?

Regards,

OssieMac

"Gone_Fishing" wrote:

I would like to keep a shared file from be altered by the users. The
"Protection" feature will not help because the users need to use the "Filters"

I would like when the wookbook is opened to always be on a designated sheet
name & cell # (sheet 1 Cell A1 or My Sheet Cell L50)

Thanks for the help

--

Dave Peterson