userform on intranet: have to enable macro every time

S

sam

Hi All,

I have an excel userform that is posted on companys intranet. Rite now once
we launch the userform from intranet we have to enable the macro everytime
its launched. Is there a way where the macro is enabled everytime we launch?
I have saved it as a .xls file and set the macro settings to "enable all
macros", but we still have to manually enable the macro.
Will saving it as .xlsm solve this issue?

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Userform on intranet: disble save option, allow open only 1
Quicker way to enable macros? 3
HELP: Excel userform version control issue 1
HELP: version control issue 14
HELP: Populate form fields (intranet) from a workbook(network driv 5
users have to manually enable macro everytime they launch userform 4
userform on intranet: disable save button on initial launch 3

Top