Module not saved

hi all

when i created any Module in my excel,
I save the code run the code , it works..

and after saving and exiting from VBA mode and exit Excel.

When i reopen the excel , and open VBA portion i dont find the Module i created earlier.

How can i save Module, so i can get it after i reopen after exiting..

Hi gaursh,

You are using a workbook that does not save the code, so When you save the workbook select the "No" option and then a file picker will allow you to select and save as "macro enabled workbook"

Please edit your profile to say which version of Excel that you are using

I already Mentioned ..its 2007

Originally Posted by gaursh

I already Mentioned ..its 2007

I can't see where, but it still needs to be in your User Profile