View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Programmactic access to Visual Basic Project is not trusted

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" schrieb im Newsbeitrag
...
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
:

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" schrieb im Newsbeitrag
...
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