File -> Options -> Trust Center -> Trust Center Setttings -> Macro Settings -> Trust Access to the VBA Project object model.
This is usually needed if you are referencing Extensibility library.
More Related Contents:
- How to find the days difference between two dates [closed]
- Excel matching based on name date and copying data to another sheet
- Get all dates between 2 dates in vba
- Different languages issue when inserting formula from VBA
- vba: get unique values from array
- Unprotect VBProject from VB code
- Can VBA Reach Across Instances of Excel?
- Excel VBA – Delete empty rows
- What is the lifetime of a global variable in excel vba?
- How to check for empty array in vba macro [duplicate]
- Use autofilter on more than 2 criteria
- What is the function of FormulaR1C1?
- Compiler Error: User-defined types not defined
- Open a workbook using FileDialog and manipulate it in Excel VBA
- Vba Excel do vlookup from a closed file
- excel hyperlink to nothing
- How to add headers to a multicolumn listbox in an Excel userform using VBA
- How to send files via HTTP_POST with Excel using VBA?
- VBA to open Excel hyperlink does not work when hyperlink generated with a formula
- How to Add Date Picker To VBA UserForm
- Vba macro to copy row from table if value in table meets condition
- Difference between Thisworkbook.name and Activeworkbook.name in VBA
- Set a cell value from a function
- How to determine if a date falls on the weekend?
- What are the differences between using the New keyword and calling CreateObject in Excel VBA?
- Excel VBA wildcard search
- VBA Check if file (from website) exists
- How do I get a list of unique values from a range in Excel VBA?
- How to get selected value in multicolumn listbox
- Query my excel worksheet with VBA