Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent User Seeing Data in Hidden Columns
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent User Seeing Data in Hidden Columns
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. Louise wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Copy and Paste Several Columns of Data into Excel... ? | Excel Discussion (Misc queries) | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
How to "ignore" hidden columns? | Excel Discussion (Misc queries) | |||
How do I prevent hidden columns from being revealed by another use | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |