MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Close a workbook on save?

Posted by Marcie on March 07, 2001 2:26 PM

I need to automatically close a workbook when the user saves it. Is there any way to do this?

Posted by VT on March 07, 2001 4:44 PM

Seemed like you would just need to write a macro for "save and then close" assign a button to it on your spreadsheet and label it something like "save&close". Just click on this button anytime u want to save and close automatically. If u don't know how to write a macro for this, just juse the macro recording function.

Posted by Marcie on March 08, 2001 8:09 AM


Yes, this makes perfect sense. Thanks!