The macro may not be available in this workbook or all macros may be disabled This is so bizarre, getting an error indicating that the macro is not available. Here is my error message: The macro I want to run is ZipAllSubfoldersinFolder. All of the other macros wor......
error: the macros in this project are disabled, please refer to the online help or documentation of the host application to determine how to enable macros. Solution 1: 检查安全中心的设置。 Enable VBA macros is "checked". Solution 2: 看看macro书不是创建在了正确的Excel object下,有时候打开太多...
Microsoft Office has identified a potential security concern. Macros in this document have been disabled by your enterprise administrator for security reasons. 原因 如果嵌入的 Excel 工作簿不是来自受信任的位置,或者新工作簿未保存到受信任的位置,则会出现此问题。
安全级别修改后，要关闭所有的excel文件，重新启动excel程序打开文件才起作用。
If you’ve disabled macros accidentally, you’ll have to close and re-open the workbook, then click the “Enable Content” button. Macro Settings in the Trust Center Excel provides settings to adjust its default behavior when opening macro-enabled workbooks. You can view these settings in the...
When opening an Excel workbook or creating a new workbook from a template, macros may be disabled depending on your macro security settings in Excel. This may disable certain functionality of the workbook. Resolution This article is not intended to provide complete information on the topic of Ex...
If the source of the file is unknown and you don't want to enable macros, you can click the 'X' button to close the security warning. The warning will disappear, but macros will remain disabled. Any attempt to run a macro will result in the following message. ...
When I start my app (C#, VS 2019), I am getting this message "Cannot run the macro 'getDynExcelVersion'. The macro may not be available in this workbook or all macros may be disabled".getDynExcelVersion - is the User-Defined Function...
无法解决，这个提示表示用的宏已经遭到破坏或已经不存在了。
Cannot run the macro <macro name >. The macro may not be available in this workbook or all macros may be disabled. Resolution Important This section, method, or task contains steps that tell you how to modify the regist...