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
Highlighted

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

Related Conversations
Teams no longer auto launches
trandall in Microsoft Teams on
4 Replies
vba sending email w/ attachment
katrina bethea in Excel on
7 Replies
VBA - Splitting worksheet by Dept
Zia Siddique in Excel on
12 Replies
Userform Listbox HELP
R3d3mpt10n in Word on
1 Replies