![visual basic for excel 2016 visual basic for excel 2016](https://blogs.sap.com/wp-content/uploads/2015/09/103_792756.jpg)
The macro consists of a userform, Module 1, This Workbook and code in one of the sheet if that helps. I have googled this to the nth degree and not found any real answers. The work around is that we copy and paste the macro text from previous workbooks and they run fine. When we open Visual Basic editor the macros are indeed gone. This happened with some people, not all and is slowly becoming an issue for everyone. To recover the macros, open a backup copy of the file if you have one."
![visual basic for excel 2016 visual basic for excel 2016](https://i.ytimg.com/vi/JLQ8OuW0FlY/maxresdefault.jpg)
"The Visual Basic for Applicataions (VBA) macros in this workbook are corrupted and have been deleted.The macro corruption most likely exists in the current file. By installing this update, you can help protect your computer. But all of a sudden a week ago we started getting the following error message when we tried to enable macros when opening the file: An identified security issue in Microsoft® Visual Basic® for Applications could allow an attacker to compromise a Microsoft Windows®-based system and then take a variety of actions. Hopefully, other forum users have more useful answers. Looks like VBA language is based on these two. It did occur to me that Libre Office might handle the visual basic macros as I found this comment, 'The most recent versions of LibreOffice can run some Excel Visual Basic scripts if you enable this feature at LibreOffice - PreferencesTools - Options - Load/Save - VBA Properties.'. We have had the same macro in this file for many many months without issue. Select default language for edition: English (this option probably isnt neccessary but I did this when i looked for solution) Set English from order list as top of language for display Set English from order list as top of language for help.
VISUAL BASIC FOR EXCEL 2016 UPDATE
We as an organisation have an excel macro enabled workbook file template that we have been downloading from our company website to update and then reload onto said website.