Use time and date to trigger delete of sheets and userform

[Mikeymike_W]

Hi,

I was hoping that someone could help me. I am wanting to use the date and time to trigger the delete of certain sheets in a workbook as well as a userform... if all the code written in VBA could be deleted then that would be grand too!

I would want the code to be triggered after one year, however if possible it would be great if a message box would be prompted 1 week before deletion to warn the user... is this at all possible?

Many thanks for any help you can provide, i'm not even sure where to start with this :/

Mike