VBA to delete number of sheets based on days in current month

Hello!

I have a template that has 31 sheets (named '1,' '2,' '3' etc.). When the template is opened, I need a macro that tests for the number of days in the current month and then deletes the sheets that don't exist in that month (i.e. if the template is opened in April, it will delete sheet '31' as there is no 31st day of April).

Would someone please be able to help me with this?

I have attached my workbook so you can see what I'm talking about

Thank you!

try this code, dont know if it works for the Mac though.

Please Login or Register  to view this content.

Thank you for this! Do you have a way I can test it though? Because there are 31 days in March it won't delete anything haha!

Thank you!

Simply change the date on you computer to another month.

Of course! Thank you - it works perfectly!