Hi all,

Someone at work asked me how to keep information hidden in an excel spreadsheet - she sends round budgets, and wants to hide the payroll information.

My first thought was to hide the columns and then protect and hide the worksheet. I then realised that you can still see the information that is in the cells in a protected worksheet - if you type in the cell in the name box, the contents will come up in the formula bar.

I guess you could come up with workarounds for that (like putting the information in cell CA8131), but it's a bit clumsy. Is there any better, practical, relatively fool-proof way?

Thanks a lot

Adam