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!