| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Security setting on Low, but Macro will not run?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro not able to run due to a security setting | Excel Discussion (Misc queries) | |||
| Macro won't work due to Security Setting? | Excel Discussion (Misc queries) | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
| Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) | |||
| Macro Security Setting not applying | Excel Programming | |||
Threaded Mode
