Not sure which Version you're using but!

In 2010.

Go to Developer | Macro Security | Macro Settings...

Under:

Developer Macro Setting, make sure "Trust access to the VBA project
object model" is checked.

Earlier Versions may be:

Tools | Macro | Macro Security.

HTH
Mick.