hide and protect

[smisar]

I have an excel sheet on which I made some pricing calculations. Say I made a price calculator in which price appears in a cell based on quantity input. This works well with hide and protect...

Now when I copy this protected entire sheet and paste into new sheet, all info is revealed..

can someone suggest hoe to protect and hide so that no one can reveal?

 

[sudipto3003]

except copy paste, use save as

 

[Smallman]

Excel is not really good at this sort of thing. If you want to lock your program down tight you probably dont' want to use Excel. You are a bit restricted as no matter what you do there will almost certainly be a work around. Probably not the answer you wanted, sorry about that.

Take care

Smallman

 

[SirJB7]

Hi, smisar!
I'm bad news, check this:
http://chandoo.org/forum/threads/wh...t-method-to-secure-workbook.11962/#post-70156
Regards!