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.
相关问题
- Excel sunburst chart: Some labels missing
- Error handling only works once
- Error handling only works once
- Excel formula in VBA code
- Excel VBA run time error 450 from referencing a ra
相关文章
- Get column data by Column name and sheet name
- programmatically excel cells to be auto fit width
- Unregister a XLL in Excel (VBA)
- Unregister a XLL in Excel (VBA)
- How to prevent excel from truncating numbers in a
- numeric up down control in vba
- Declare a Range relative to the Active Cell with V
- What's the easiest way to create an Excel tabl
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".
In Excel, go to
File > Options > Trust Center > Trust Center Settings > Macro Settings
and select an appropriate setting to use.