VBA Macro code not Displaying

[deanmoakes]

Hi All,

I tried searching but could not find an answer to this, Does anyone have any thoughts?

I have a .xlsm workbook that has a few modules in it with various code.
It is a file that other people use but I maintain and update.

I have today gone into the file to amend a macro following a request but it is not showing me the code.
The macro's still run so I know that the code is still in the file.

I have tried view code, Double clicking on the module, Right click view code.
When I double click the VBA project title nothing happens either which is strange (Normally you get a box appear where you can lock the project).

Hopefully someone has a way that I can get the code back as there is quite a lot of it.

Thanks Dean

 

[Joe4]

Did someone lock the code, or make it very hidden?

 

[deanmoakes]

Did someone lock the code, or make it very hidden?

I can see the modules in the VBA screen so its not locked and I have not hidden them.
What is odd is that it wont open the VBA properties box.
The users of the file do not have the best excel knowledge so i doubt that they would be able to make it not visible.

Ive never had this in years of using VBA.

 

[Joe4]

Did you try re-booting your computer and try again, in case something got messed up with Excel?

If that does not fix it, it is possible that your file may have become corrupted.

 

[Alex Blakenburg]

This might be worth a try:
”At the top of the code window (in the menu bar)... click on Window... and then Cascade
the child window is most likely just moved off the edge of the screen and that should reset it.”
by braX at VBA Excel: Module visible in the project explorer, but not the code window

 

[deanmoakes]

Ok, Tried a restart same issue.
Tried cascade but same issue. I can see other code windows from other files just this file.
I have also tried to export the modules but it will not let me do that either.

Its like there is a lock on them.

Any idea's what could be causing the locking?

 

[Alex Blakenburg]

Just curious, what happens if when you are in the spreadsheet, you hit alt+F8.
Can you see the macros ?
If Yes then what happens if you select a macro and hit edit ?

 

[deanmoakes]

Just curious, what happens if when you are in the spreadsheet, you hit alt+F8.
Can you see the macros ?
If Yes then what happens if you select a macro and hit edit ?

Hi,

I get the macro window but no macro's listed.
Macro's in the file are run using buttons and are working fine with no issues.

 

[Alex Blakenburg]

Do you want to try this?
VBA window shows list of modules but does not show any code - OzGrid Free Excel/VBA Help Forum
If it works please post what you did.

PS: I am login of for the night. It’s past midnight in Sydney Australia

 

[deanmoakes]

Hi That also did not work.
I have asked to see if we can get the file restored from the backup servers.
Can then bring across any data that has changed.

Thanks for your help.