users have to manually enable macro everytime they launch userform

  • Thread starter Thread starter sam
  • Start date Start date
S

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
 
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.
 
And if the button(?) that launches the userform calls a macro in another
workbook, then you could see that security prompt, too.
 
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.
 
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.
 
Back
Top