Ouka,
Is the project protected/signed ?

NickHK

"Ouka" wrote in message
...

ok, figured out the error message was part of an error handling script I
included and forgot about. commenting out that script I still error out
in this app on all machines except the machine I wrote it on.

I have narrowed down the error to this line of code:

Dim TempForm as Object
Set TempForm = ThisWorkbook.VBProject.VBCompenents.Add(3)

Here of course I'm trying to add a form at runtime. But why would the
above code not work on anymachine but the one I've developed the app
on??


--
Ouka
------------------------------------------------------------------------
Ouka's Profile:
http://www.excelforum.com/member.php...o&userid=23988
View this thread: http://www.excelforum.com/showthread...hreadid=401595

No, no protections are enabled.

The problem seems to be this line:

Set TempForm = ThisWorkbook.VBProject.VBComponents.Add(3)

A copy/paste of this line in it's own procedure will open a userform
upon execution on my dev box, but returns a 1004 error on other boxes.

If this line works on the dev box but not on others, mayhap there is a
reference that is enabled on my box that others don't have??


--
Ouka
------------------------------------------------------------------------
Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988
View this thread: http://www.excelforum.com/showthread...hreadid=401595

Have you checked
"Trust Access To Visual Basic Project"
via Macros, Security, "Trusted Sources"

Regards,
Peter T

"Ouka" wrote in message
...

No, no protections are enabled.

The problem seems to be this line:

Set TempForm = ThisWorkbook.VBProject.VBComponents.Add(3)

A copy/paste of this line in it's own procedure will open a userform
upon execution on my dev box, but returns a 1004 error on other boxes.

If this line works on the dev box but not on others, mayhap there is a
reference that is enabled on my box that others don't have??


--
Ouka
------------------------------------------------------------------------
Ouka's Profile:
http://www.excelforum.com/member.php...o&userid=23988
View this thread: http://www.excelforum.com/showthread...hreadid=401595