Closing open xlsm workbooks individually

Scuff

New Member
Joined
Jun 20, 2012
Messages
2
OK, so I've got a few Excel 2007 workbooks containing macros. It seems that sometimes when I want to close one of them I must go through and save and close all open excel documents first. Until I do the close button does nothing, neither does right clicking on the task bar and hitting close or File and close or Alt+F4, etc etc. Only after closing every other open excel document first can I then go back the one I want to close and close that too.

They're opened in individual windows (it's not the old click the little X and not the big one problem), and there are no macros or processes that should be running at the time of trying to close. It doesn't happen all the time, I've just opened 2 workbooks I use frequently and closed them individually without a problem. I haven't yet found a trend as to when it occurs, although I'm sure there must be one.

It something I can cope with, an annoyance but in a way a good way of forcing me to make regular saves I guess. But I write these for other people at work to use and frequently get asked "Why does it do that?". I hate having to admit that I have no explanation!

Any one come across this? My Google-Fu has failed me thus far...
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Bam! Found the cause!

The workbook is protected, and I was wrong, I was opening it in the same instance of excel as some other excel docs.

Solutions:
1. Don't protect the workbook (needless to say it's protected for a reason so I won't be doing that)
2. Deliberately open a new instance of Excel and run the workbook in that to segregate it from my other open workbooks (hassle, and not suitable for my users)
3. Probably the most likely solution - Write a close macro to save the workbook, unprotect it and close it, and add this to a nice chunky button on the front page.
 
Upvote 0

Forum statistics

Threads
1,212,046
Messages
6,105,583
Members
447,972
Latest member
carrieann

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top