Visual Basic Code Keeps Disappearing in Excel 365

Question

I have VBA code in the Activate procedure for a number of Worksheets in a file I use every day. Almost every day now I am having use backup to replace code that disappears. Can anyone help me with this problem?

Answer 1

I recommend to keep a copy of the file before you run it again. This continues to be a problem, it has occurred several times and again just now for me, I can retrieved a backup and replace the code behind it keeping the data within the sheets but this is a pain in the butt.

Answer 2

Hi Clifford

I'm Femi and I'd happily help you with your questions. In this forum, we are Microsoft consumers just like yourself.

I’m sorry to hear that your Visual Basic code keeps disappearing in Excel 365. This seems to be a common issue that many users have reported after the latest update.

Sometimes, the Office update may cause some files or settings to be corrupted or missing, which can affect the Visual Basic functionality. You can try to repair your Office installation by following the steps in the link below

https://answers.microsoft.com/thread/f91595b8-9538-4462-875f-1ad1204354ee

I hope this helps, let me know if this is contrary to what you need. I remain helpful in answering more of your questions.

Best Regards,

Femi.

Give back to the community, and help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.