I have experience in using excel but not setting it up so I am not faliliar
with the specific terms or proper names of features. So with that in mind -
I'll start over again.

#1
I would like the sheet to be protected so that the text (it is all text) and
the column widths etc. can not be changed. But I would like the users to be
able to use the AutoFilters to find their particular info.

#2
The sheet has Freeze & Split Frames to preserve department names on top and
product related data on the left side. In the upper left corner there is a
"merged" group of cells serving as a intro to the sheet and a link to the
user instructions on sheet 2. Sheet 2 has a link back to sheet 1. This make
Cell E6 the start of the horiz & vert scroll section. Some times when the
file is reopened, it reopens somewhere in the vert & horiz scroll area.
(we'll say L50) I would like it to always open at the beginning of the sheet
(E6) starting position.

Thanks for your help.

"Dave Peterson" wrote:

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