Excel run VBA marco with error after upgraded O365 version

%3CLINGO-SUB%20id%3D%22lingo-sub-1497587%22%20slang%3D%22en-US%22%3EExcel%20run%20VBA%20marco%20with%20error%20after%20upgraded%20O365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497587%22%20slang%3D%22en-US%22%3E%3CP%3EI%20got%20a%20excel%20file%20which%20contains%20visual%20basic%20marco.%20It%20worked%20perfect%20fine%20in%20excel%20previous%20version%2C%20but%20after%20upgraded%20to%20O365%2C%20then%20it%20sometimes%20prompt%20error%2C%20and%20that%20even%20cause%20copy%20%26amp%3B%20paste%20hangs%20up%20excel.%20Please%20help.%20See%20screendump.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EError%20prompt%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.screencast.com%2Ft%2FumpKurCUAlA%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.screencast.com%2Ft%2FumpKurCUAlA%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emarco%20xls%20file%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.screencast.com%2Ft%2FCOt2PDQ61FU%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.screencast.com%2Ft%2FCOt2PDQ61FU%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1497587%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-1497617%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20run%20VBA%20marco%20with%20error%20after%20upgraded%20O365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497617%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713931%22%20target%3D%22_blank%22%3E%40RG10025%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnlock%20the%20VBA%20project%20and%20upload%20the%20file%20again%20here%20itself%20to%20view%20the%20code%20which%20is%20causing%20that%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I got a excel file which contains visual basic marco. It worked perfect fine in excel previous version, but after upgraded to O365, then it sometimes prompt error, and that even cause copy & paste hangs up excel. Please help. See screendump.

 

Error prompt:
https://www.screencast.com/t/umpKurCUAlA

 

marco xls file:
https://www.screencast.com/t/COt2PDQ61FU

 

3 Replies
Highlighted

@RG10025 

 

Unlock the VBA project and upload the file again here itself to view the code which is causing that error.

Highlighted

@Subodh_Tiwari_sktneer No lock at all. But still uploaded the attachment here.

Highlighted

@RG10025 

 

You misunderstood. The file is not locked but the VBAProject is locked i.e. you cannot view the code unless you have the password.

 

Refer to the following screenshot.

 

VBAProject Password 2020-06-30 11.13.15.jpg