Right click the small excel icon in the upper left of the screen just to the
left of FILEview codeselect workbookselect before closeinsert your
codesave.

--
Don Guillett
SalesAid Software

"Cindy" wrote in message
...
I have a macro that I am running now via a hot key

I would like to modify to use Workbook Close event.

I have never done this before how do I do it?

Thanks
Cindy