Suppress "project unviewable" messagebox on close

[pjbassdc]

Hi All,

I am trying to close out of a shared workbook and close excel. I would like to keep my workbook shared as a group of 4 or more may access it at the same time. After all my saving has been complete, I close out with the following snippet.

Please Login or Register  to view this content.

All seems to work fine, but at the end of it all I see the message box :

pl.JPG

and

a box wanting to restart Excel.

rs.JPG

Other than not having a shared workbook, is there any fixes to suppress these?


Thank you,
Patrick

[xladept]

Quit after you close.

[pjbassdc]

Thank you for the help.

After rearranging the code, the error stopped.

I am still trying to get a full close on Excel. I don't see anything in the project browser hanging around. Any ideas on getting this window to close in the code?

Capture.PNG


Patrick

[xladept]

That's not happened to me - do you have screen updating turned off

[shg]

What's your code now?

[pjbassdc]

I looked back through the code and didn't see anywhere I left the screen updating set to false.

The code below is where I am calling various subs.

Please Login or Register  to view this content.

And here is my closing sub that is leaving the empty excel window open.

Please Login or Register  to view this content.

Any ideas on why the screen doesn't shut down?


Patrick

[shg]

Is wb1 or wb2 the workbook containing the code?

[pjbassdc]

wb1 is where I have most of my code. Some code in modules, some on sheet, some in a userform.

[shg]

So if you close wb1, the workbook that contains that code, how are the next two lines going to execute?

[pjbassdc]

Yep, seems kinda pointless.

So, I have been messing around with the code a bit. Looking for other clues online but have yet to get the result I am looking for. If I leave the workbook un-shared everything seems to work without an issue. When the workbook is shared (desired situation), the code runs and leaves me with the situation in post #1.

Perhaps something is hanging up I can't see. The project opens 2 workbooks. The main workbook is shared and the other not. Not rightly sure why that should make a difference when quitting the application.


Patrick

[shg]

My point is, the workbook running the code should close all other workbooks first, save itself, then quit the application. It can't close itself and then quit the application.