Grouping versus outline and copying data onto new row
Posted by Edwin on September 15, 2001 12:51 AM
This is a repost of questions that were unanswered in this forum
1) I have constructed a spreadsheet that has certain formulas that I would like to have protected and hidden, and as well I have grouped and outlined those rows containing the formulas.
The problem occurs when I have protected the sheet (hence protecting the formulas) but I am thus unable to expand and collapse the outlined rows. Is there anyway I am able to achieve both my objectives of allowing a freely expanding and collapsing outlines of rows in the sheet as well as protecting and hiding formulas in certain cells that are within those rows that are collapsed.
2) I have another sheet where there is a new set of information posted onto it daily. I would like to construct a button that will allow me to at the press of the button and have these selected cells be copied and pasted onto a new sheet as a new row.
Eg. My sheet is used to track stock count in my warehouse. Thus every morning, I would have a few figures namely, opening stock, closing stock and say net stock. I would like to have the button to copy these data (which might not be on the same row or same column on the sheet but rather scattered throughout the sheet) onto a new sheet as a new row. Thus the new row should look like (from left to right) date, opening stock, offtake, closing stock and net stock.
Furthermore, I would like that new sheet with the new row to calculate the change in the net stock from a day to day basis.
3) I would also like to have the workbook to be such that everytime the sheet is printed, the footer would show something like "Written by Edwin", to claim authorship to the workbook. I did receive a response from someone on this forum who suggested me setting some sort of VBA code to enable this, but since I am unfamiliar with VBA code, I am unable to come up with the code. Furthermore, I need to know, how can we prevent someone from changing this code. I know Excel has a in-built function which allows you to set the header or footer, which is basically what I want, but is there a way to prevent others from changing it, by a password or otherwise.
I would appreciate any help rendered. Thanks.