Workbook_Open Help

[ScabbyDog]

I have the following code in my Workbook

Please Login or Register  to view this content.

So basically when I run my excel file it calls the above macros. UpdateTime and UpdateDate refresh the current time and date every second. The other 3 macros rely on the current time/date to run. So when a date is within 2 days of the current date it will run the twodaysbeforeprices macro. But what I want to know is that if I open the excel sheet a week before anything is due to happen and leave the workbook open will the macros run themselves automatically once the date gets refreshed and is within 2 days of the cell that contains my date? OR, would I have to use another code such as Workbook_Calculate or something along those lines to make what I want work???

Thanks in advance.

[rvasquez]

Hello there,

You would need to run a different code as this code only accounts for the On Workbook Open event.

[ScabbyDog]

What code would I need?

[rvasquez]

It's a little hard to imagine your workbook but I believe the On Calculate Event should work if you leave the workbook open.

[ScabbyDog]

Thanks for your help rvasquez. So in my workbook I should have the below code or am I wrong?

Please Login or Register  to view this content.

[rvasquez]

Yes, I believe that should work for you. But this also assumes that you will not be entering data or manipulating any cells in the meantime or else the code will run everytime you do so.

[ScabbyDog]

I tried it there but when I changed the date in the cell to make it within 2 days it didn't run the macro. Should the OnCalculate code be in the workbook or the module itself and if it's in the module does anything additional need to be placed in the Workbook code?

[rvasquez]

Try the on worksheet change event

Please Login or Register  to view this content.

This should be in the same area as your on workbook open Event. Under ThisWorkbook.