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

Userform on intranet: disble save option, allow open only 1
HELP: Excel userform version control issue 1
HELP: version control issue 9
HELP: Populate form fields (intranet) from a workbook(network driv 3
userform on intranet: disable save button on initial launch 3
users have to manually enable macro everytime they launch userform 4
HELP: Trying to populate form fields posted on intranet from a dat 2
not able to enable macro in password protected .xlsm workbook. 2

Top