error "Macros is not available in this workbook or

2019-09-14 21:11发布

I have developed an customized ribbon in excel and some macros using Visual Basics Script. Also, after completing when I send my excel to another computer along with add-ins I am getting error "Macros is not available in this workbook or macro may be disabled. Please be noted that I created add-ins and added the add-ins too but still I am getting this error. Kindly help me with this issue. Thank you.

2条回答
唯我独甜
2楼-- · 2019-09-14 21:45

Aside from what CLR wrote (and using the Excel file in the xlsm format), I noticed that if I run this VBS in a batch mode, it only gives me results if the batch is run "as an Administrator".

查看更多
forever°为你锁心
3楼-- · 2019-09-14 21:47

In Excel, go to File > Options > Trust Center > Trust Center Settings > Macro Settings and select an appropriate setting to use.

查看更多
登录 后发表回答