Jun 29 2020 09:57 PM
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
Jun 29 2020 10:37 PM
Unlock the VBA project and upload the file again here itself to view the code which is causing that error.
Jun 29 2020 10:40 PM
@Subodh_Tiwari_sktneer No lock at all. But still uploaded the attachment here.
Jun 29 2020 10:45 PM
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.