Home

HOLD SHIFT key to disable auto_run vba not supporting anymore

%3CLINGO-SUB%20id%3D%22lingo-sub-490233%22%20slang%3D%22en-US%22%3EHOLD%20SHIFT%20key%20to%20disable%20auto_run%20vba%20not%20supporting%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490233%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHOLD%20SHIFT%20key%20to%20disable%20auto_run%20excel%20vba%20macros%20not%20supporting%20anymore.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20because%20of%20any%20recent%20update%20or%20do%20I%20have%20to%20repair%20or%20re-install%20office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-490233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490838%22%20slang%3D%22en-US%22%3ERe%3A%20HOLD%20SHIFT%20key%20to%20disable%20auto_run%20vba%20not%20supporting%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490838%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329100%22%20target%3D%22_blank%22%3E%40ishubhardwaj%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20but%20the%20way%20it%20works%20for%20me%20is%20to%20open%20the%20workbook%20using%20the%20Open%20command%20in%20Excel%20not%20to%20open%20it%20directly%20from%20the%20local%20drive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.jkp-ads.com%2FArticles%2Fpreventopenevent.asp%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
ishubhardwaj
Occasional Visitor

Dear All,

 

HOLD SHIFT key to disable auto_run excel vba macros not supporting anymore.

 

Is it because of any recent update or do I have to repair or re-install office 365.

 

Thank you.

1 Reply

Hi @ishubhardwaj,

 

I'm not sure but the way it works for me is to open the workbook using the Open command in Excel not to open it directly from the local drive.

 

Please check out this link.

 

Hope that helps