Re: SHEET SET UP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm using 2003 and I'm sure everyone else is using at least 2003
I am doing a spread *** as a volunteer for our local hosp. I am tracking
the products used vs. departments. They should be able to open the filter
arrow in their dept header (along the top) and get the products in their
depts. On the left is the other half of freeze & split tha show Mfgr -
product name & web link to the Mfgr site

I just had a major problem develope - I tried to hide the unsed columns &
rows (it worked) but when I saved it after about 6 hrs of input and reopened
it, *** 1 (the main *** with all the info shows for a second and then
turns into a blank gray screen. The coulmn identifers along the top (A - B-
C- etc) are still there but the Row identifers (1 - 2 - 3- etc) are gone.
This just happened about 30 mins ago.



"Dave Peterson" wrote:

If you're using xl2002 or newer, then you can lock the cells on the work***.
(select all the cells, format|Cells|Protection tab|check locked)

Apply the freeze panes
Apply the data|Filter|autofilter

Then protect the work***.
(tools|Protection|protect ***, check the "Use Autofilter" option)

======
But you didn't include the version of excel that you and the other users are
running. And you didn't include anything about what you meant by sharing.

Gone_Fishing wrote:

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 *** 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 *** 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 *** and a link to the
user instructions on *** 2. *** 2 has a link back to *** 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 ***
(E6) starting position.

Thanks for your help.

"Dave Peterson" wrote:

Just to add to OssieMac's response.

This option to allow autofilter in work*** 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 work*** 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 ***
name & cell # (*** 1 Cell A1 or My *** Cell L50)

Thanks for the help

--

Dave Peterson


--

Dave Peterson

.

Quantcast