| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform on intranet: disble save option, allow open only | Excel Programming | |||
| Use UserForm to Access Spreadsheet on Corporate Intranet? | Excel Programming | |||
| how do i enable macro in Excel and Access at the same time | Excel Discussion (Misc queries) | |||
| Enable ESC to canel UserForm | Excel Programming | |||
| How to put to work an Excel macro in intranet? | Excel Programming | |||
Linear Mode
