VBA windows in Excel 2007?

  • Thread starter Thread starter newbie
  • Start date Start date
N

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
 
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
 
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.
 
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
 
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
 
Back
Top