Home

When I run a program from my Excel spreadsheet it stops running as it opens another soreadsheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-481112%22%20slang%3D%22en-US%22%3EWhen%20I%20run%20a%20program%20from%20my%20Excel%20spreadsheet%20it%20stops%20running%20as%20it%20opens%20another%20soreadsheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481112%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20macro%20worked%20fine%20previously%20%2C%20but%20now%20%2C%20as%20soon%20as%20it%20opens%20another%20spreadsheet%20to%20put%20downs%20some%20data%20the%20macro%20stops%20running.%20All%20that%20changed%20is%20that%20we%20moved%20to%20Microsoft%20Office%20Proffesional%20Plus%202016.%20Am%20I%20missing%20something.%20Some%20other%20macros(different%20spreadsheet)%20are%20running%20fine.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-481112%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-489325%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20run%20a%20program%20from%20my%20Excel%20spreadsheet%20it%20stops%20running%20as%20it%20opens%20another%20soreadsheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-489325%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325510%22%20target%3D%22_blank%22%3E%40Bertusbypersal835%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20there!%26nbsp%3B%3C%2FP%3E%3CP%3EWich%20version%20were%20you%20using%20before%3F%20Sometimes%2C%20a%20few%20pieces%20of%20code%20won't%20work%20the%20same%20way%20when%20upgrading%20to%20a%20new%20Excel%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Bertusbypersal835
Occasional Visitor

This macro worked fine previously , but now , as soon as it opens another spreadsheet to put downs some data the macro stops running. All that changed is that we moved to Microsoft Office Proffesional Plus 2016. Am I missing something. Some other macros(different spreadsheet) are running fine. 

1 Reply
Highlighted

@Bertusbypersal835 

Hi, there! 

Wich version were you using before? Sometimes, a few pieces of code won't work the same way when upgrading to a new Excel version.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies