preventing accidental file closure

[thoandros]

Dear forum
I have a macro that closes and saves a file. I would like to see if it's possible to find a way that I cannot close the file/window with the X in the top right X button - so that the only way to close that particular file, if open, is to use the macro I've created. Is it possible? thank you for your help!

[mehmetcik]

That is Simple when you know how.

In the Workbooks, "ThisWorkbook" Macro module there is an option:

Please Login or Register  to view this content.

Change that to:

Please Login or Register  to view this content.

You can never close the Workbook.

Declare a Global Variable CloseFlag as Boolean. Set that to True using your Macro and use the code:

Please Login or Register  to view this content.

[thoandros]

Hello mehmetcik thanks for that.
I think that would work, but I guess I need to give you a couple more information.

I have a file, called RUMDOM.xlsm
This is the file I've always open on the background and where the macros to Open and Close file Guide.xlsx.
Guide file cannot be a macro enabled file.

However, Guide.xlsx is the only file that I have to make sure I only close by launching the macro from RUMDOM file. Am I making sense?

Would that work also if Guide cannot be .xlsm?

Is it something that I can add in the OPEN macro that CLOSE macro will then remove before Guide.xlsx is saved and closed?

[mehmetcik]

There is a possible mechanism that might work.

I will have a look at this and get back to you.

Ok this works.
The CloseGuide macro writes in Cell A1 of Sheet(1) of Guide.

Please Paste the "Guide" macro inside a frequently used Macro in Rumdom [ But not too Frequently ]. Is can even be inside a sheet spefic macro.
Like: Worksheet: Change, Selection_Change, Activate etc.

You could even create a Workbook Open Macro inside Rumdom that opens "Guide.xlsx" and then runs the Guide Macro.
In fact that is the route I would take.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[thoandros]

thank you, I will review this later today or tomorrow and let you know.

[thoandros]

thank you for this!