Thisworkbook.Close <true/false/blank

Followed by True to save the changes or False to save with out changing.
Leave blank after and excel will prompt you.

Nick

"Pam C" wrote in message
...
If I have a macro to automatically run a macro when the workbooks opens,
what
do I add to make Excel close after the macro finishes running.

Thanks,