Hi OssieMac,
Sorry for the delay in response; I've been away. I tried this, but it
seemed to make no difference. Also, I'm not sure that setting is
workbook-specific, so I'm not sure that I can ensure that my users who go to
run my spreadsheet in 2003 will necessarily have the setting correct all the
time.

--
Don H.


"OssieMac" wrote:

Hi again Don,

Another suggestion. This time partially tested. Ensure that all xl2007 code
is in a module of its own. (Previous posts suggest that is what you already
have.)

In the VBA Editor select Tools - Options - General tab.

Check the box Compile on demand.
Uncheck the box Background compile.

My limited testing suggests that this works.

Unless the project is extremely large then it might not noticable affect the
speed.

Also, I believe that once the code has compiled once then it does not
continually re-compile every time it is used. You can test this by running
some of the code and then open the VBA editor and select Debug - Compile and
you will see that compile is disabled because it is already compiled. Some of
the expert might be able to enlarge on this aspect.

--
Regards,

OssieMac