userform on intranet: have to enable macro every time

  • Thread starter Thread starter sam
  • Start date Start date
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
 
Back
Top