Prevent User Seeing Data in Hidden Columns

[Guest]

Hi,

Can anyone help me, I need to hide some columns so that the end user doesn't
see them, I have hidden them but there is nothing to stop them unhiding them
and seeing what lies beneath. I can't put this data on a hidden sheet as it
doesn't recognise the data in my pivot tables etc...

How can I do this, but so that the customer can still run calculations etc
on the remainder of the report?

Any help gratefully received...

Thanks,

 

[Dave Peterson]

If you put any data in a worksheet and share that data with others, then there
is nothing you can do to stop the recipient from seeing that data.

Don't trust Worksheet protection. It is easily broken.