Where'd my code window go?

[IMAFriend]

I do lots of various scripts and macros with Excel.

Today I try to make a macro and ... my code window is blank, or empty.
I have the project explorer, and the properties, but where's my code
window?

I try new excel workbook, make macro, nothing.
I try edit exciting, nothing.
It's jsut empty. I can't find my code window!!

Anyone help?
thanks!

Excel 2003

 

[Gary Keramidas]

you could have minimized it. close the project and immediate window and see if
you see it. other than that, i don't know.

 

[3texinohio8]

It sounds like you are recording the macro inside a workbook module
then closing the workbook and not saving the changes. Click the Record
button and see what is says under "Store macro in:" in the Record
Macro window. If it says: "This Worlbook", either change it to
Personal Macro Workook, which resides on your computer, or be sure and
save the workbook you recorded the macro in after you record it. If
you record the macro into the Personal Macro Workbook module, be sure
and save when Excel promts you to. This will occur when you close
Excel.

If this is not the case and you are recording the macro into your
Personal Macro Workbook and saving them, maybe your project VBAProject
window is closed. Click on View, click on Project Explorer. If your
VBAProject windows is open, make sure that you click on the + beside
VBAProject (Personal.xls) until you find the module with your code.

Just some ideas

Alan

 

[IMAFriend]

Gary, thanks for the thoughts. That was tried already.

Alan, thanks for having some cool wire-tap on my computer, because you
saw exactly what I did.
I just wanted a temporary macro. I had a bunch of stuff that was
pasted from elsewhere, including 1/400, 2/402, (1 of 400) and I
didn't want the 4 of 7 ( 4/7) to show as a date, so I was playing
around with formatting and started to write a macro just to fix the
format or erase the error message.

Anyway, I just wanted a temporary macro, so I chose 'save in this
workbook' instead of the default personal macros... and probably
didn't save.

It's all fixed now. Appreciate it much!
DougB