One way to HIDE data in Rows/Columns is to HIDE the Rows/Columns. When the person with the proper stuff gives the proper password, you UNPROTECT the sheet and UNHIDE the Rows/Columns and then REHIDE the Rows/Columns & REPROTECT the sheet when they are done.
And if you want to protect the data from being read then try this out:
You need to enter a few parameters and then read a few output cells you would set up an input and output sheet and then have all parameters and calculations on a different sheet. If the results cells (on the calc sheet) are then named, and the output on the input/output sheet only refers to them by name the users will be none the wiser about the inputs.
If you take this approach, name the calc sheet something obscure/alphanumeric and then write a quick macro:
Sheets("obscure_name_here").visible = xlveryhidden
Then protect the VBA Project (rightclick and complete the protection tab), then you can protect worksheets/workbook as you see fit and, unless the other users guess the name of worksheet or the VBA Project password it should be reasonably safe. There are still ways round it though if the other users are a bit good.
|