This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
All files that conteins macros (VBA Projects) do not work, and ask me to recover it, and then automatically delete VBA codes, without being able to recover those codes or edit then.
I have done the following:
* Uninstall and reinstall Office 2010, complete, including the VBA (they are installed) (I used first 32 bits and then 64)
* Also I trayed to install office 2016, I've got the same problem
* Check that all VBA references are updated and installed (no missing objects or dll's)
* Macro security fully enabled
* I make a file with VBA macros from scratch, it works at that time, but when closing and lifting it again it appers the same error (VBA disappears).
* These files works perfectly in other notebook (with the same office and Windows)
Working with MSACCESS, all the databases that have VBA (inside the forms) do not work, it says it cannot find VBA projects.
* Try to repair the office
* Also re-install the Windows
* All Windows updates are loaded correctly.
Investigating a bit, it seems that the problem is not in the office, which is apparently an error in the update of Windows 10, but so far I find no solution, and I'm really desperate and in a hurry. What can I do, please. This problem appers 5 days ago
I am using Windows home 10 (1903), Compile SO 18362.449 64 bits
Kind regards
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This issue can be caused when you open a xlsm-file, with "wrong" language settings and there are "foreign" characters (like: æ, å, ä, ü ) in the variable or module names. Try to change language for non-Unicode programs in regional settings.
Kind regards
Sorry I'm out of ideas. I thought that password protecting the VBA code would do the trick at least.
If you save the file to a memory stick - does the VBA still vanish?
And tell me what happenes when you do this....
Is the VBA still there?
I assume so, so
Wait 30 seconds and open the workbook with File/Open and not a double-click in Explorer
Has the VBA gone?
The cell entries you made - are they still there?
If all else fails then put the hard disk through a check before doing anything else - using something like CHKDSK or WMIC just in case it's a FAT problem.
Suggest you check your virus scanner logs - I seem to remember that McAfee did this thinking it was a virus
Thank you again GreyNewt, unfortunately steel with the problem, I hope I don't have to format the entire disk to re install all applications, in a business enviroment that is not a good solution, but if I do not find any other thing could be my last action.
Kind regards
LOL - no! I use a different one myself. But a good virus checker should be alert to dangerous macro code - specifically code that writes (which is almost every one).
Interesting that it happens with Access VBA as well - which does point the finger at an external software.
If I were you i would copy the files with VBA to the computers hard disk, disconnect access to the internet and disable the virus checker - then see if it still happens.
Also - if you password-protect the VBA code then even a virus checker will be unable to access it - so try that as well.