Display message after workbook.open

[brainzlp]

Please Login or Register  to view this content.

That's what i have and i need to display the message after Workbook.open:

Please Login or Register  to view this content.

Hope someone help me out with this

[JLGWhiz]

The only thing that I see is that you made the host workbook read only. Try commenting out that line and see if the message then shows. Although the message box is a Windows feature and not just Excel.

[brainzlp]

It does a reebot on active workbook and open it in read-only.

Although even with the messagr uncommented as you can try it does show message before opening...

[brainzlp]

I really need to display some kind of information after workbook open in shutdown macro

[JLGWhiz]

I am looking at the code and wondering why you are opening a second instance of the same workbook as read only when you have already made the first instance read only. Better yet, why have two instances of the same workbook open at all?

[brainzlp]

I am looking at the code and wondering why you are opening a second instance of the same workbook as read only when you have already made the first instance read only. Better yet, why have two instances of the same workbook open at all?

I really need that do be like that cuz i have external data and more users to enter, this is the only way that external data doesn't go with error.

It opens the same workbook, not 2 of the same... saves 1 and opens the same as read only.

Let me know if there is a way to close a workbook with a msgbox displayed or userform please

[JLGWhiz]

Under normal circumstances, the message box would display when called in the code, because it is part of the Windows application and not just on the Excel/VBA platform. I have been trying to understand what the rest of the code is doing that might cause the Windows application to ignore the call for the message box. I have tried to set up a couple of tests but cannot duplicate the condition. Everything I tried resulted in the message box displaying as it should. I have not tried what your code does, because I don't understand the logic of it. But I am pretty sure that the method you are using is related to the condition.

[brainzlp]

Just test this in a normal module and see that After the file is opening, no msgbox is created..

Please Login or Register  to view this content.

Thanks for trying to help, it's really importing to have this working

[brainzlp]

I've check and it's impossible. I created a new page and select it before open the workbook.

Thanks anyway