Excel
Posted by K Stewart on June 25, 2001 6:53 AM
I want to send a fairly complex excel file to someone as an attachement to an email. Is it possible to protect this file in such a way that only permits the receiver to print the file. I need to protect the formulas etc!
K Stewart
Posted by Joe Was on June 25, 2001 8:00 AM
Hide formulas
Most Excel methods to hide something are spicific and only hide a certain part. Unfortunately, all the easy password lock and hide tools available can allow the user to see the formulas, rather easily.
Some level of protection can be had by; referencing the cells you do want to be seen, on a new sheet. Then hide the called sheet. Excel will then show the cell formula for the call and not the called formula. Name the cell being called then reference that cell by name. (Under some circumstances Excel shows the called formula, naming the cell helps to hide Excel's helping you.)
I hope someone else has a better code solution for you? JSW
