无法解决,这个提示表示用的宏已经遭到破坏或已经不存在了。宏安全性设置成启用所有宏就可以了~你用的什么版本的excel?设置的地方不太一样~
I have an encrypted Excel file with macros. It's run fine on several computers over time. Tonight I just installed Office 2007 on a new Microsoft...
I have an Excel file that contains macros—they all run perfectly - when I record a NEW macro it does not run when invoked - I get a loud tone , but no error message—please help preston99 Put the macro in a module and let it run through that. If the macro has an error, then ...
You assign a macro to an object in an Excel worksheet. After you copy the worksheet to a new Excel workbook in Microsoft Office Excel 2007, the macro does not work in the new workbook and you receive the following err...
in_ApplyTypes_result=self._oleobj_.InvokeTypes(*(dispid,LCID,wFlags,retType,argTypes)+args)com_error: (-2147352567,'Exception occurred.', (0,'Microsoft Excel',"Cannot run the macro ''test_macro.xlsm'!TestMacro'. The macro may not be available in this workbook or all macros may be ...
以前,我们经常通过Excel宏实现一些自动化的操作控制,比如启动Power Query刷新数据,刷新完毕后再将数据...
Then based on your error message >>"Cannot run the macro 'SOLVER.XLAM!GetSolverLabel'.<< Please try to do the following methods to fix the issue: 1. Open VBE (Alt+F11)>Click Tools> References>set to SOLVER>Show immediate code pane (Ctrl+G)>Copy/paste (or write): application.run ...
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 ...
For example, since Ctrl+B applies bold font, you cannot assign that shortcut key to your macro. By default, Excel stores the macro in the current workbook, making it available to run whenever the workbook is open. If you want your macro to always be available no matter what workbook you...
After you install this update, when you click on a shape that has a digitally signed macro assigned to it, you may receive the following error: Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled. ...