Lost Visual basic modules

[Slade]

Hello,

In Excell when I created a new visual basic code, or recorded a
new maco it stored it under a Module such as Module 1, Module 2 etc.
When I saved my workbook the modules saved with it. So the next time I
opened that workbook I could go directly to the VB editor and find my
VB codes under the appropriate "Module #".
Recently, I tied to go back to some older Excel workbooks to look
at my old VB scripts. However, when I enter the Visual basic editor
there are No modules listed at all. If I record a new macro it will
once again create a "Module 1" and create the VB script.
Any idea where my older scripts are and why I can not see them
anymore?

Thank you,
Slade

 

[Norman Jones]

Hi Slade,

In my experience, code modules do not spontaneously disappear.

If, when writing your code, more than one workbook was open, it is possible
that the code was created in a workbook other than the intended repository.

Alternatively, perhaps, after writing or recording code, the workbook was
inadvertently closed without being saved.