Hiding data in an ExcelSheet

  • Thread starter Thread starter tmarko
  • Start date Start date
T

tmarko

I have the following problem:

The user produce a report that is placed in an empty
Excelsheet (an application). Then the user sometime later
wants to update the report. For this I need to store some
parameters that decide what Report the user wants to
update and the results be placed in the same Excelsheet. I
do not want the parameters to be visible for the user.

I decided to try to produce a hidden sheet when the user
first create his/her report. This hidden Excel sheet's
name is exactly the same as the visible data with an
additional suffix so I can keep track which hidden sheet
belong to which visible sheet . Several Reports can be
found in different sheets in a single workbook.

The problem is that my users want to be able to change
sheet names. By doing this my application can't find the
correct hidden sheet to the correct visible sheet so the
application can update the visible sheet with correct
report.

Is it possible to set something else than sheetname so I
can "link" 2 sheets to each other?

Or is there an other way to store the hidden parameters in
a the visible sheet? I do not want to use any cells,
rows/columns that can be used for the Report. The user
should not be aware of these parameters.

I read something about CUSTOMdocumentproperties, but this
just apply to a workbook. But I need to save unique
parameters per sheet.

(Excel 97)
 
What about just changing the font color to white (or whatever your
bground color is) of whatever you don't want them to see?
 
bimmerman:

No beacause I do not know how big the reports will be so
where should I place the parameters to be sure that it
wont interfere with the visible data and the user may add
some additional data himself below the report aftre the
report has been created. No I do not want to interfere
with the visible data if that is possible. I never know
what the user will do.

Thanks anyway
 
I've had similar problems and so far this has worked.
Pick a row or column away from usable report cells in the sheet, put in your
formulas, and format cells on number tab as custom, then enter ;;; in the
box. This will make the contents invisible.
As an added precaution, right click the columns or rows and select hide.

Good luck
 
Back
Top