VBA windows in Excel 2007?

[newbie]

I was typing in some code in, Excel 2007. I clicked the microsoft
icon, got the developer tab up and got into VBA. I put in some code
for a subroutine i found that i wanted to try out. I named the
subroutine, and named the file and exited. Now i cant find out how to
get the VBA code window back to see the code i put in! Help! how do i
get my code back? Some how Excel 2000 was easier to work with.

Andrew

 

[Ron de Bruin]

Hi Andrew

If you have set your default save format to xlsx your code is gone.
Did you not read the message when you save the file ?
Change the format to xlsm to save the code in your workbook

Office Button>excel Options > Save
See the first line

 

[Dave Peterson]

alt-f11
should still get you to the VBE.

But then you'll have to look through the general modules or worksheet modules or
the ThisWorkbook module to find your code.

 

[newbie]

Darn! i didnt know that! i guess my code is gone! thanks for the hint,
i new would have known that!
I did office button/excel options/save/
in the first line there is save files in this format. Can you expand
on what i am supposed to save format in? to save my code?
right now its stuck with only the one pull down menu pick list

Andrew

 

[Ron de Bruin]

xlsm is the format with or without code Andrew

If you save with code maybe you want to read this
http://www.rondebruin.nl/saveas.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Darn! i didnt know that! i guess my code is gone! thanks for the hint,
i new would have known that!
I did office button/excel options/save/
in the first line there is save files in this format. Can you expand
on what i am supposed to save format in? to save my code?
right now its stuck with only the one pull down menu pick list

Andrew