Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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 "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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. 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 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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. "Dave Peterson" wrote: 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. 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 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 -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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 wrote: 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. "Dave Peterson" wrote: 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. 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 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 -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
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. "Dave Peterson" wrote: 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 wrote: 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. "Dave Peterson" wrote: 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. 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 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 -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
SHEET SET UP
I've never seen simply sharing a file cause this problem.
But glad you got things working. Gone_Fishing wrote: 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. "Dave Peterson" wrote: 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 wrote: 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. "Dave Peterson" wrote: 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. 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 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |