View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Security setting on Low, but Macro will not run?

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