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

glad to help

--
Don Guillett
SalesAid Software

"Cindy" wrote in message
...
Nevermind...... I found it and thanks for your help!

"Don Guillett" wrote:

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