Chris,

You need to change a setting in Excel:

Tools|Macros|Security|Trusted Publishers and then check Trust Access to
Visual Basic Project

hth,

Doug

"cjmd" wrote in message
oups.com...
Thanks for the reply. I must be doing something wrong as I get
"Run-time error '1004': Programmatic access to Visual Basic Project is
not trusted" when I try to run the macro.

I added the With Application . . . End with to my
UserForm_initialize(), and added the UserForm_Terminate() function. I
tried declaring the Boolean variables in General Declarations and then
in the initialize() function but get the run-time error either way.

Thoughts?
Chris