Re: Programmactic access to Visual Basic Project is not trusted

From: keepITcool (xrrcvgpbby_at_puryyb.ay)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 13:16:23 -0800

NOTE:

if you are using Excel 2003 the box in
macro security options is greyed out.

the registry setting was moved from user to machine
and you can no longer change it from the UI.

Run the program regedit.exe
goto:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Excel\Security
Add or Change a DWORD named AccessVBOM to Value 1 

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
Frank Kabel wrote in message
<news:OETc560yEHA.2040@tk2msftngp13.phx.gbl>:
> Hi
> goto 'Tools - Macros - Security' and on the second tab of this dialog
> allow access to the VBA project
> 
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
> 
> "Peter" <scotsman@xs4all.nl> schrieb im Newsbeitrag
> news:u2Fwz30yEHA.2752@TK2MSFTNGP11.phx.gbl...
>> Hello everyone,
>>
>> Because of this piece fo code: ...
>>     Dim ModuleCount as Long                 (?)
>>
>>     ModuleCount = ThisWorkbook.VBProject.VBComponents.Count
>>     Sheets.Add After:=Sheets(ModuleCount)
>>
>> I get this error message:
>> "Programmactic access to Visual Basic Project is not trusted"
>>
>>                                                 (What good is it
>>                               then?) 
>>
>> Does anyone know how to circumvent this?
>>
>>
>> TIA
>>
>> Peter
>>
>>
>