Allow code to run once then not until it's trigger value appears again

When A5=40, the code below is called, which activates another sheet to print it.

Sheets("bulk").Select
Sheets("bulk").Activate
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
MsgBox "You have just printed the completed PAB30 form"

Maybe I should change the code that returns 40, to the "bulk" sheet, and put your code in that sheet instead of the one I have it now.

Thanks for your persistence.