CLosing Excel 2007 with personal macro workbook


G

Guest

When I close Excel 2007, all open worksheets are closed with a Save Changes
prompt where needed. However, Excel itself doesn't close. It requires a
second click of the close button. It took a little research to discover that
this behavior is due to the presence of the Personal.xls macro workbook,
which I need. It seems I now have to click Close twice or hold the shift key
while closing Excel if I want to use Personal.xls, even if none of my macros
have changed. No other Office app behaves this way, nor has Execl ever done
this before 2007.

Is there a setting or fix/workaround/hack to prevent this behavior? It's
very irritating.
 
Ad

Advertisements

J

Jim Rech

A workaround would be to put ThisWorkbook.Saved = True in Personal.xls in
Sub Auto_Close or in Sub Workbook_BeforeClose in the ThisWorkbook module.

You would just have to remember to explicitly save Personal when you make a
change to it.

--
Jim
| When I close Excel 2007, all open worksheets are closed with a Save
Changes
| prompt where needed. However, Excel itself doesn't close. It requires a
| second click of the close button. It took a little research to discover
that
| this behavior is due to the presence of the Personal.xls macro workbook,
| which I need. It seems I now have to click Close twice or hold the shift
key
| while closing Excel if I want to use Personal.xls, even if none of my
macros
| have changed. No other Office app behaves this way, nor has Execl ever
done
| this before 2007.
|
| Is there a setting or fix/workaround/hack to prevent this behavior? It's
| very irritating.
| --
| Kato Wilbur
|
 
Ad

Advertisements

R

Ron de Bruin

If you use this
You must copy it in a normal module, the Workbook_BeforeClose event is in the thisworkbook module
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top