Looking for Excel Time Bomb to delete worksheet based on future date

Hello Team!

Looking for help writing a VBA to delete a time based (quarterly) worksheet based on a future date.
I've been looking at Chip Pearson's version "TimeBomb With A Defined Name" or similar but having a hard time putting it together.
I have two other Private Sub Workbook_Open() on the worksheet and they're working well.
However, my attempt to add an additional Time Bomb comes up with a Compile error: Ambiguous name detected: Workbook_Open

I've been working on this spreadsheet for many years and would like to protect the hard work I've put into this project.

Any help or suggestions would greatly be appreciated!

Rob Surina
Douglas Michigan

Thank you for moving my post to the appropriate place