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:
> 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
[quoted text clipped - 4 lines]
>
> Thanks for you advice
Dave F - 18 Oct 2006 14:00 GMT
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

Signature
Brevity is the soul of wit.
> Format cells containing a formula as locked and hidden (Cells
> formatting/Protection) then protect the worksheet (possibly with a password)!
[quoted text clipped - 12 lines]
> >
> > Thanks for you advice
Gord Dibben - 19 Oct 2006 00:39 GMT
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
>Format cells containing a formula as locked and hidden (Cells
>formatting/Protection) then protect the worksheet (possibly with a password)!
[quoted text clipped - 12 lines]
>>
>> Thanks for you advice
JGG - 19 Oct 2006 08:19 GMT
Please can you point me in the direction of compiling the spreadsheet as a
COM add-in
Thanks
> JGG
>
[quoted text clipped - 43 lines]
>>>
>>> Thanks for you advice
Gord Dibben - 19 Oct 2006 17:55 GMT
JGG
Start here at MSDN site.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/o
dc_OFCallVBAFromAddin.asp
Gord
>Please can you point me in the direction of compiling the spreadsheet as a
>COM add-in
[quoted text clipped - 48 lines]
>>>>
>>>> Thanks for you advice
JGG - 20 Oct 2006 10:52 GMT
Thanks
> JGG
>
[quoted text clipped - 56 lines]
>>>>>
>>>>> Thanks for you advice