Home

Macro disabled

%3CLINGO-SUB%20id%3D%22lingo-sub-339069%22%20slang%3D%22en-US%22%3EMacro%20disabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339069%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20im%20taking%20a%20business%20stats%20class%20and%20am%20required%20to%20have%20excel%20and%20an%20add%20in%20called%20megastat%20installed%20for%20the%20class.%20I%20followed%20all%20the%20add%20in%20installation%20instructions%2C%20including%20enabling%20macros%20before%20downloading%20megastat%2C%20and%20every%20time%20I%20try%20to%20use%20said%20add%20in%2C%20i%20get%20the%20error%20message%20%22cannot%20run%20the%20macro%20'MegaStat_Menu%22.%20The%20macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20may%20be%20disabled.%22%20I've%20gone%20into%20the%20trust%20center%20and%20marked%20all%20macro%20options%2C%20all%20with%20VBA%20project%20model%20checked%20and%20unchecked%2C%20Ive%20added%20the%20workbook%20to%20trusted%20locations%20or%20whatever%20its%20called%2C%20Ive%20uninstalled%20and%20reinstalled%20excel%20and%20megastat%20and%20tried%20different%20ways%20of%20downloading%20the%20add%20in%20probably%2010%20times%20now%2C%20Ive%20gone%20through%20apps%20and%20features%20and%20tried%20%22repairing%22%20excel%2Foffice%20365%2C%20Ive%20gone%20to%20the%20actual%20megastat%20file%20location%20and%20right%20clicked%20every%20file%2C%20selecting%20properties%20and%20selecting%20a%20box%20saying%20allow%20this%20program%20to%20not%20be%20blocked%20by%20windows%2C%20I%20had%20the%20workbook%20saved%20a%20an%20.xlsx%20and%20changed%20it%20to%20the%20macro%20enabled%20.xlsm%2C%20and%20Ive%20tried%20yelling%20work%20dangit%20repeatedly%20while%20running%20cirlces%20around%20my%20computer%20with%20no%20luck.%20No%20matter%20what%20I%20do%2C%20I%20keep%20getting%20the%20same%20error%20message%20and%20im%20about%20to%20go%20insane.%20Does%20someone%20have%20an%20idea%20on%20how%20to%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-339069%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
SpelWurdsRite
Occasional Visitor

So im taking a business stats class and am required to have excel and an add in called megastat installed for the class. I followed all the add in installation instructions, including enabling macros before downloading megastat, and every time I try to use said add in, i get the error message "cannot run the macro 'MegaStat_Menu". The macro may not be available in this workbook or all macros may be disabled." I've gone into the trust center and marked all macro options, all with VBA project model checked and unchecked, Ive added the workbook to trusted locations or whatever its called, Ive uninstalled and reinstalled excel and megastat and tried different ways of downloading the add in probably 10 times now, Ive gone through apps and features and tried "repairing" excel/office 365, Ive gone to the actual megastat file location and right clicked every file, selecting properties and selecting a box saying allow this program to not be blocked by windows, I had the workbook saved a an .xlsx and changed it to the macro enabled .xlsm, and Ive tried yelling work dangit repeatedly while running cirlces around my computer with no luck. No matter what I do, I keep getting the same error message and im about to go insane. Does someone have an idea on how to help me?

Related Conversations
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
Collapse and Expanding Worksheet Tabs
Nguyen Giang in Excel on
15 Replies
sum by color when colors are set by conditional formatting
matt nipper in Excel on
197 Replies
Compile error: Method or data member not found
kevin whiteside in Excel on
5 Replies
Re: Macro to save as PDF with auto filename as cell value
Joe Gray in Excel on
23 Replies