Re: How best to distribute Excel 2003 spread*** with VBA Macros?

Ok perhaps I didn't make that too clear JP... the entire spread*** file is
an "application". It includes worksheets, forms, modules, formulas, range
names, etc. Altogether it's nearly 10 MB.... not exactly Add-In material.
LOL!

- Michael


"JP" <jp2112@xxxxxxxxxxxxx> wrote in message
news:8328527e-19ba-4f5c-90f2-69c1acd365bb@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
If you distribute your workbook as an add-in, it should avoid this
problem.

Do a Google search for "how to create add-in excel" there are many
websites with instructions.


HTH,
JP

On Mar 13, 12:44 pm, "Michael" <Michael211_NoS...@xxxxxxxxxxxx> wrote:
Ok not as simple as it may sound! LOL!

I have an Excel 2003 spread*** app that needs to be distributed within
the
organization I work for. However, many of the users of this spread***
will
be mobile and often not connected to any network (stand alone users). The
spread*** has VBA macros I've written of course. Now everytime we try to
open the spread*** on any PC besides the one I developed it on, there's
this 20 something second delay before the "Enable Macros?" warning message
pops up... I believe it's looking for my self-signed digital certificate
from my development PC on every other PC we try to run the spread*** on!
Since that certificate was a "self-signed" certificate it only exists on
my
development PC.

The startup delay while Excel times out looking for that certificate is
unacceptable. How do I handle this? We can't use an internet based
certification authority as many times the user's PC's won't be connected
to
the internet at all (the file will be sent to them on memory sticks and
cd's).



.