VBA Modules lost

Question

Hi, 

I use a lot of macros in my work. Some are in my personal macro workbook, which is in OneDrive and some are in the Excel files I use them in. VBA still shows all modules in my personal macro workbook in the list on the left, but I can't access them anymore (the macros not in my personal workbook work just fine). They don't run and VBA doesn't display the code upon double-clicking. Depending on from where I try to run them (button, lint etc.), I may or may not get the error message that the macro can't be run and that it might not be available in this worksheet or all macros might be disabled. The latter is not the case. I checked in the Trust Center. They don't show in the list that pops up by clicking Developers > Macros, so I can't step into them from there. I can't recover a previous version of the personal macro workbook, nor can I export a module. I don't know what else to try to try and recover them. 

Thanks in advance.

Answer 1

https://hooijerrenkum-my.sharepoint.com/:u:/g/personal/a\_hooijer\_hooijer\_nl/EWJEkv1S4EtBrHJR4NoBjp4B\_dGpqrd5xCOWVKUYjeObIQ?e=g505Xg

I can open the file without issues, all VBA modules and code is there.

There is only one small thing that could cause problems, some of the modules have the same name as the macros in them. That is not a fault in general, but I recommend not to do so.

I cleaned the project, renamed the modules, here is your file:

https://www.dropbox.com/s/doe1o84eshsuczu/72baf9f1-5189-4c49-a497-307c73362255.xlsm?dl=1

Does it work for you?

Andreas.

Answer 2

You're a lifesaver! Work flawlessly.

I am pleased that I could help.

I've removed the file from my Dropbox, so nobody else can download the file.

I suggest you should do the same with your file, resp. disable the download link.

Stay healthy, Andreas.

Answer 3

You're a lifesaver! Work flawlessly. You have no idea how much work you just saved me. Thanks so much!

And thanks for the tip about the naming. Will make sure I'll name modules and macros differently from now on.

Answer 4

Hi Andreas, 

Thanks for your response! Here's the link: 

https://xxxxx-my.sharepoint.com/:u:/g/personalxxxxx\_hooijer\_nl/EWJEkv1S4EtBrHJR4NoBjp4B\_dxxxxxxxxxxxxxxxxxxxxx

PII is masked by Forum Moderator

Answer 5

If you give us your file I can take a look at the binary data and see if it is possible to extract some macros.

IMPORTANT: Zip your file!

https://support.microsoft.com/en-us/windows/zip-and-unzip-files-8d28fa72-f2f9-712f-67df-f80cf89fd4e5

Login to https://onedrive.live.com (Use the same Login ID and password as for this forum).

Click Upload in the top and choose your file.

After uploading, right click the file and choose Share.

Click Copy Link in the lower left edge (no need to enter an email).

Copy the link and paste it here.

Andreas.