Anthony,

You can write your code as an ActiveX DLL callable by VBA
procedures, or you can write a COM Add-In, which too is an
ActiveX DLL that supports a special interface. Neither of these
approaches is trivial, but neither is terribly difficult if you
have a proficiency in VB programming.

You can't simply create an exe out of your VBA code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"AAAAA" wrote in message
...
Hi

I would like to know if it is possible to program my VBA code
in VB.
For example I want to prgram something in range("a1"), but I
want to do it
in VB and not in VBA. I want to do this for security purposes
as Excel is
easy to crack.

Any solutions will be helpful.

Regards

Anthony