ps.

Activeworkbook.close

will try to close the workbook that's active--not the workbook with the code.

Thisworkbook.close

will try to close the workbook that owns the code.

K11ngy wrote:

I was told to create command button and call macro quitapplication, record,
ok and the stop recording, Empty Macro?

The it says edit macro by inserting a line ActiveWorkbookClose after the
comments?

I assume this is in VB but I really dont know where in Vb to enter the
above. Tried everything but no success

Help

Steve

--

Dave Peterson