Call a Workbook open procedure

[andrewb90]

Hello all,

I have a workbook open procedure that runs when the user opens the workbook (obviously). The code is looking for a validation code depending on the current date. The user has the open of entering the code into the sheet and then I would like to run a macro to check if that is a correct code. Basically I would like to run the workbook open code. Is there a simple way of doing this?

 

[Michael M]

It might be more advisable to put a copy of the code into a Worksheet_Change event, rather than calling the Open code again !

 

[andrewb90]

Good idea! thank you!

 

[Boller]

Or you might want to put the code in a separate normal macro and call it from the Workbook Open procedure and from the Worksheet Change procedure.
This will make things easier in the event that you need to change the code in future.