VBA code dissapeared!

[Filip Vermote]

Yesterday I closed my .xlsm workbook without any remarks.
It contains a lot of macro's and settings.
However, by opening this morning I received a warning that the VBA-project cannot be found.
All the modules are there, but all the VBA code dissapeared!
These are the two warnings in attachment.
Can anyone help me? What happened?

 

[Joe4]

If everything you say is true, then it sounds to me like the most likely scenarios are either:
- the file has become corrupted
- it was saved in the wrong format (a format which does not allow VBA code)

Was the file saved with a "SaveAs" yesterday, where the file type may have been changed?

Hopefully, you have a good backup of the file that you can restore to.

 

[Filip Vermote]

Thanks so much for you reply, the file is always saved the same way because it's also a macro which saves it.
I will try to recover it, I hope at least, I will inform you how this goes further!

Filip

 

[Joe4]

OK.

the file is always saved the same way because it's also a macro which saves it.

If you want to paste the section of the code that saves the file, we can review it to see if there are any obvious issues with it.

 

[Filip Vermote]

This is the VBA-code:

Sub Sluitaf()

'Save macro

'---Setting the exact frame views

Application.ScreenUpdating = False
Sheets("Hoofdschakelbord").Visible = True
Application.Goto Reference:="Hoofdmenu"
ActiveWindow.Zoom = True
Sheets("Combolijst").Visible = False
Sheets("Grafiek").Visible = False
Sheets("Grafieken").Visible = False
Sheets("VSI-data").Visible = False
Sheets("Data").Visible = False
Sheets("Percentages").Visible = False

'--- saving HPU-tool

With ActiveWorkbook
.Save
.Close
End With
End Sub

 

[Joe4]

OK, it is not even doing a "SaveAs", just a "Save".
So I don't see any issue there.

Sounds like your file may have become corrupted.

 

[Filip Vermote]

Maybe but the same file opens without problems on my colleague's laptop... Could it be excel itself that has a problem?

 

[Joe4]

So, it works on some computers, but not others?
And yuo can see the VBA code on the other computers, but not yours?

Have you checked/verified that the computer is set to allow VBA code (and not automatically disable it)?

If so, then it may be a matter of that installation of Excel being corrupted on that computer.
You may need to re-install it on that computer, and make sure that you have all the lastest patches and upgrades.

 

[Filip Vermote]

That's what I also thought to do, after it's installed I will get you informed.
Thanks anyway for your help!

 

[Joe4]

You are welcome.

Best of luck!
I hope that fixes things for you.