View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
cjmd cjmd is offline
external usenet poster
 
Posts: 2
Default Can a non-modal form be viewed w/o Excel in the background?

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