How you are saying the macro is disabled?

I think you need to call that userform using show method in a procedure. like

userform1.show

CS.