How to get an error notification box to pop up on opening the workbook -Excel already open

[Oriya]

Hey all,

Bit of a weird question this one.

I've got an excel workbook that needs to be on manual calculation - Otherwise it will go really weird and constantly recalculate infinitely! So i've got some code to do this.

Please Login or Register  to view this content.

The only issue is if the person has excel workbooks open already then it doesn't force manual calculation mode.

So I was thinking it would be good to have an error message box pop up on start up (if they have already got excel open) to let them know to close down all other instances of excel before they proceed with using the file.

Anyone got any ideas please?

[dangelor]

Possibly...

Please Login or Register  to view this content.

[JLGWhiz]

Please Login or Register  to view this content.

The 'Workbook_Open' event occurs when the file holding that macro is opened and the Calculation mode is set when the macro runs, not when Excel application is opened. If the macro is not running when your workbook is opened, or the Calculation mode is not being set to manual, then you have another problem like the event trigger being turned off, which can be done with Excel being active when the Workbook_Open event occurs. I am not sure what to recommend without being able to see the conditions under which you experience the problem.

[Oriya]

I'm happy with the code I've got for workbook_open i just wanted a message box to pop up if there was more than one excel file open and tell them to close everything and reopen.

[Oriya]

No worries I found this here: https://www.mrexcel.com/forum/excel-...eady-open.html

and adapted it into this and it seemed to do the trick:

[JLGWhiz]

Thanks for the feedback,
regards, JLG