SHEET SET UP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Yes I mean the Auto Filter. I have looked at and tried the options and they
haven't
worked. Column widths can still be altered - which mangles my "merged cell"
text box

Also on the start point when reopening the file I forgot to mention that
there is a split screen being used. So the cell I'd like the sheet to always
open to is E6 = the start of the horiz & vert scroll.

If a macro is needed I don't know.

Thanks for your help
 
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?)
 
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.
 
If you're using xl2002 or newer, then you can lock the cells on the worksheet.
(select all the cells, format|Cells|Protection tab|check locked)

Apply the freeze panes
Apply the data|Filter|autofilter

Then protect the worksheet.
(tools|Protection|protect sheet, 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.
 
I'm using 2003 and I'm sure everyone else is using at least 2003
I am doing a spread sheet 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, sheet 1 (the main sheet 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.
 
It sounds to me like you hide all the rows.

I'd do this.
Unprotect the worksheet first
edit|goto
type: 1:65536
format|row|unhide

Then scroll up to see if you can see everything.

If that doesn't help, make sure you turn of the Freeze panes and try scrolling
up.


Gone_Fishing said:
I'm using 2003 and I'm sure everyone else is using at least 2003
I am doing a spread sheet 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, sheet 1 (the main sheet 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.
Click to expand...
 
Thanks for the help
I tried all kinds of things including your suggestion
I finally noticed the wookbook was "shared"
I went into help and found out how to be selfish and NOT share.
I saved it & closed it - I reopened it and it stayed open instead of going
to the blank page == It worked (so far)
I guess I'll give up on the fancy stuff until I'm done - then save a million
copies of it BEFORE I try anything fancy.
Thanks again
I really appreciate it.
 
I've never seen simply sharing a file cause this problem.

But glad you got things working.

Gone_Fishing said:
Thanks for the help
I tried all kinds of things including your suggestion
I finally noticed the wookbook was "shared"
I went into help and found out how to be selfish and NOT share.
I saved it & closed it - I reopened it and it stayed open instead of going
to the blank page == It worked (so far)
I guess I'll give up on the fancy stuff until I'm done - then save a million
copies of it BEFORE I try anything fancy.
Thanks again
I really appreciate it.
Click to expand...
 
Back
Top