We help IT Professionals succeed at work.

Excel VBA line not working

zack4x4
zack4x4 asked
on
Hi All

   I installed Office 2003 on a reinstalled laptop (I'm the programmer) and tried running a program that runs on every other machine and it's erroring out on this line

      For Each ctl In Application.VBE.CommandBars.FindControls(ID:=varItem)

   Any idea why?

Thanks - Zack
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Go to the macro security settings and see if the

"Trust access to the VBA project object model"

is checked.

Author

Commented:
It is.  There must've been something not installed with Excel or shared tools because I went into the setup and installed all Excel and all shared tools, etc and its now working.  Very weird...  Oh well, thanks though!

Zack

Explore More ContentExplore courses, solutions, and other research materials related to this topic.