userform on intranet: have to enable macro every time
 

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

userform on intranet: have to enable macro every time
 

http://www.vbaexpress.com/kb/getarticle.php?kb_id=379

Also, set tools Macros Security Low.


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"sam" wrote:

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