Ken,

Yeah. That's absolutely right. I meant to mention that any workbooks
containing macro code would have to be saved. Take heart, Rick. It never
takes as long the second time.
--
Earl Kiosterud
www.smokeylake.com

"Ken Wright" wrote in message
...
If however you recall a message coming up when you closed Excel saying
'You have made changes to your Personal macro Workbook - Do you wish to
save those changes" and you hit no, then that is likely where the code
went and is now lost.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Earl Kiosterud" wrote in message
...
Rick,

Your code, whether you write it yourself in the VBE, or record it with
the macro recorder, goes into modules kept in a workbook. In the VBE,
the Project Explorer (a pane usually open at left), which is in outline
format, lets you open various modules.

Open any workbooks you'd have had open. Then go to the VBE (Alt-F11).
If there's no Project Explorer, do View - Project Explorer. Each open
workbook is a project, and if there's a Personal.xls workbook (which can
also contain macros), you can open the modules of that too. The projects
may be collapsed (there'll be a +, click it to expand). Double-click
each module, hoping you'll find the one that has your code.
--
Earl Kiosterud
www.smokeylake.com

"Rick, United Kingdom"
wrote in message
...
Ok I know this sounds pretty silly, but. How do you save VBA code. spent
all
of yesturday putting down loads of code, saved the work book and closed
down,
came back to it this morning and nothing! lost the lot. As you can
imagine,
not a happy teddy bear!