Hiding formula

[JGG]

I am hoping to make my spreadsheet commercially available therefore I want
to want to protect my formulae by making it invisible to prying eyes and
through auditing. I can out some in a password hidden sheet but some cells
need to appear on visible sheets. Can I somehow make the formula invisible
on the input bar or should can I prevent te input bart appearing. I ma
uising Excel 2002

Thanks for you advice

 

[Guest]

Format cells containing a formula as locked and hidden (Cells
formatting/Protection) then protect the worksheet (possibly with a password)!

Regards,
Stefi


„JGG†ezt írta:

 

[Guest]

You should be aware, however, that Excel passwords are very easy to crack,
and so I wouldn't bet you fortunes on creating a "commercial" excel workbook
from whose proceeds you can retire.

Dave

 

[Gord Dibben]

JGG

A note here........Excel internal passwords for sheet and workbook protection
are very easily cracked.

Posted by JE McGimpsey........................

In general there is no internal XL security that can't be bypassed by a
moderately interested person who can find these newsgroups. See:

http://www.mcgimpsey.com/excel/removepwords.html

http://www.mcgimpsey.com/excel/fileandvbapwords.html

Your best bet for anti-piracy would be to redesign and compile your
spreadsheet as a COM add-in.

End JE post..................................


Gord Dibben MS Excel MVP

 

[JGG]

Please can you point me in the direction of compiling the spreadsheet as a
COM add-in

Thanks

 

[Gord Dibben]

JGG

Start here at MSDN site.

http://msdn.microsoft.com/library/d...n-us/dno2k3ta/html/odc_OFCallVBAFromAddin.asp


Gord

 

[JGG]

Thanks

JGG

Start here at MSDN site.

http://msdn.microsoft.com/library/d...n-us/dno2k3ta/html/odc_OFCallVBAFromAddin.asp


Gord