View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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