Lost Visual basic modules
 

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

Lost Visual basic modules
 

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.


---
Regards,
Norman


"Slade" wrote in message
oups.com...
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