Sounds like the users have security set to High. They have to reduce it
manually (Tools, Macro, Security) or they cannot run your macros. There is
nothing you can do to force this.

--
Jim Rech
Excel MVP