users have to manually enable macro everytime they launch userform
 

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

users have to manually enable macro everytime they launch userform
 

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

users have to manually enable macro everytime they launch userform
 

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

users have to manually enable macro everytime they launch user
 

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

users have to manually enable macro everytime they launch user
 

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