Excel VBA - distribute secure solution

Yes. You have 2 options

1) Create an Excel AddIn
2) Use Vb.Net to create a COM DLL file.

Sid

Not sure if this still applies in 2010, but could you not secure your VBA project with a password??

>>>Not sure if this still applies in 2010, but could you not secure your VBA project with a password??

Yes, it does apply but VBA passwords are easy to Hack :)

Sid

I'm a believer :)

So Am I teylyn So Am I :)

Sid

you can create addin for excel 2010

check below link
http://msdn.microsoft.com/en-us/library/cc668205.aspx

Sid, shall we hold hands and dance around a lamp post doing "Singing in the rain"?

That happens only in Indian Cinemas. I like the opening scene though :|

Sid

I think you should.

Back on subject this is the age old question of protecting code in VBA, a relatively pointless exercise if trying to protect from the dishonest, but simple password protection should suffice to deter someone who doesn't care much anyway. So yes, go with Teylyn's suggestion of password protection on the VBA and lock for viewing.

Sid, next time I'm in India, you'll have the honor to arrange a lady's night out for your wife, her 6 to 12 best friends, and me to go see a super-mega-heart-wrenching chick flick Bollywood movie. Make sure to arrange for some tasty nibbles to keep us interested during the interval and the dull scenes.

(Does that not sound miles better than "eat my shorts"??) :)

>>>(Does that not sound miles better than "eat my shorts"??) :)

Any Day! Arf Arf Arf...

You are most welcome :)

@murbro: Sorry for 'hijacking' your thread :)

Sid

Hi. No problem. Made the conversation a little more interesting :)

The reason I mentioned that I am giving this to an IT company is that they will definitely hack it.
I have time constraints so building an add-in might be tricky
What about the whole digital certificate  thing - is that not worthwhile.
My client is prepared to pay the one or two hundred dollars.
Need a fast secure approach.
Thanks

Hi. What about doing an Excel Workbook project in Visual Studio Tools for Office. You take the existing Workbook with its VBA and deploy that. Is this secure as is, ie can it be reverse engineered or should I add some further code protection.

Thanks very much