Excel 2007 hangs on programmed file close

R

Richard MG

I am working in Excel 2007 with SP1. I have a workbook with VBA that works
fine except that the Module that closes the workbook, using
ActiveWorkbook.Close, hangs Excel when run. If I step through the code it
closes normally and Excel doesn't hang.

The same workbook running in 2003 works fine.

What causes this and how do I stop it?
 

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