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
|