Re: Programmactic access to Visual Basic Project is not trusted

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 23:22:00 +0100

Hi Jurgen
for me (using Excel 2003 / German) no problem to change this setting in
the UI directly. But I'm logged in as admin. So could be the reason for
this 

--
Regards
Frank Kabel
Frankfurt, Germany
"keepITcool" <xrrcvgpbby@puryyb.ay> schrieb im Newsbeitrag
news:Xns95A2E2A432B3Ekeepitcoolnl@207.46.248.16...
> 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
> >>
> >>
> >
>