Compile error in my Application
 

I have created a VBA application that prevents users from being able to

open an Excel spreadsheet without first accepting the terms &
conditions, sent to about 1,300 users.

I have 2 versions, v1 appears to work fine, with v2 (which prevents
users from being able to copy or cut (or edit in any way) the data once

they open the Workbook), when some users (a small minority) open a
Workbook they get a "Compile error in hidden module: ThisWorkbook"
error.


The App. does write code to ThisWorkbook so I appreciate that the error

is in there somewhere, but I have been unable to replicate the issue
and am therefore a little stuck.


Does anyone out there know what type of error I need to look for and/or

why it is only a problem for a small minority?


Thx in advance


Si

Compile error in my Application
 

Si,

Your code looks ok to me. <g
Are they using the same operating system/version?
Are they using a different version of Excel?
What are the security settings on their machines?
("Trust access to Visual Basic Project")

Assume you can't go to the location where the problem occurs...
so give the password/instructions to someone there and have
them unlock the project.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"elloss" wrote in message...
I have created a VBA application that prevents users from being able to
open an Excel spreadsheet without first accepting the terms &
conditions, sent to about 1,300 users.

I have 2 versions, v1 appears to work fine, with v2 (which prevents
users from being able to copy or cut (or edit in any way) the data once

they open the Workbook), when some users (a small minority) open a
Workbook they get a "Compile error in hidden module: ThisWorkbook"
error.
The App. does write code to ThisWorkbook so I appreciate that the error
is in there somewhere, but I have been unable to replicate the issue
and am therefore a little stuck.
Does anyone out there know what type of error I need to look for and/or
why it is only a problem for a small minority?
Thx in advance
Si

Compile error in my Application
 

Thx Jim

It's a Global org, so in theory !! should abe on the same platform,
also have checked Excel versions. Low security settings would prevent
them from seeing the data but would give them the macroless version
which would direct them to change their settings.

Have since maganed to find an individual who can replicate the issue (I
have 2 days to fix until he goes back to the US) so any further ideas
much apprecited ;0)

thx again

Si

Compile error in my Application
 

Have resolved the issue but thought I'd post solution in case anyone
comes across this in future.

I had erroneously added an unnecessary reference to the Project (in the
application) "Lotus Domino Object" (which was originally used for E
mailing a response back to the centre, but code changed to late binding
when early wouldn't work).

In Excel 2003 the superfluous reference caused basic functions such as
UCase, Right, Left etc not to be recognised.

Simon