users have to manually enable macro everytime they launch userform

[sam]

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]

How are you launching that userform?

Where is that userform located? If it's in a workbook that needs to be opened,
you could see that security prompt.

 

[Dave Peterson]

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

 

[sam]

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]

If this is a button from the Forms toolbar, then rightclick on tha button and
choose Assign macro.

Is it pointing at a different workbook?

If it is, then reassign the correct macro to the button and test it again.

I'm guessing that it's going off to open another workbook.