View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Msgbox to make a choice

You need to allow it in Tools=Macro=Security

I believe it is in the trusted sources tab (a checkbox). (I don't have
xl2002/xl2003 handy at the moment).

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Hi,

I ran it as a separate macro and I'm getting 'programmatic access to
Visual Basic Project is not trusted' on this line:
Set UF = Application.VBE.ActiveVBProject.VBComponents.Add(3 )

Thanks,

Michele