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,