Pop-up message if Workbook opened between certain times

[Lifeless]

Hey all,

I was wondering if you could possibly help me with this..

I'm wanting to display a Popup message if the workbook is opened between the hours of 8:30am and 9:30am
How do I go about doing this?

Many thanks

[sourabhg98]

Hey there,
Yes that is possible.
Check attached.

To run a macro you need to follow these steps-

Save and close all open workbooks.
Open a new workbook, and then start the Visual Basic Editor (press ALT+F11).
Press CTRL+R to switch to the Project Explorer window.
In the Project Explorer window, right-click the ThisWorkbook object, and click View Code on the shortcut menu.
In the module, type the following code:

Please Login or Register  to view this content.

Hope this helps!!

Have a Great Day!!

[Lifeless]

Brilliant thanks +rep mate

Sorry to be a pain, how would I edit this to display the same pop-up between those times however this time when the user attempts to "save" the file between those times.

EDIT Never mind, I managed to figure it out. Thanks for your help!