EXCEL add in

%3CLINGO-SUB%20id%3D%22lingo-sub-2871784%22%20slang%3D%22en-US%22%3EEXCEL%20add%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2871784%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20run%20data%20analysis%20tools%2C%20even%20thought%20I%20have%20check%20the%20option%20in%20adds-ins%20and%20check%20%22Trust%20access%20to%20VBA%20project%20object%20model%22%20in%20macro%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20shown%3C%2FP%3E%3CP%3ERun-time%20error%20'1004'%3A%3C%2FP%3E%3CP%3ECannot%20run%20the%20macro%20'fDialog'.%20The%20macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20may%20be%20disabled.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2871784%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I cannot run data analysis tools, even thought I have check the option in adds-ins and check "Trust access to VBA project object model" in macro settings.

 

It shown

Run-time error '1004':

Cannot run the macro 'fDialog'. The macro may not be available in this workbook or all macros may be disabled.

0 Replies