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.



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

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

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

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.

sam wrote:

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


--

Dave Peterson