Hey dave, the userform is launched by a button in an excel sheet. the same
sheet contains all the VBA for that form. It is located on the shared drive
of my company.



"Dave Peterson" wrote:

And if the button(?) that launches the userform calls a macro in another
workbook, then you could see that security prompt, too.

sam wrote:

even after changing macro setting to enable all macros, users have to enable
macro every time they launch the form. am i missing something?

Thanks in advance

--

Dave Peterson