I have a workbook with many sheets labelled properly, but occassionally my colleagues add a new sheet to the spreadsheet and save it which knackers my formulas.
I want to add a check in my beforeclose function that checks for sheets that begin with the word Sheet, so anything called Sheet1, Sheet2 etc is to be deleted.
What i have so far is:
Whilst this works great if there is just the Sheet1, it does not work for Sheet2 onwards as I cant quite figure out how to loop the code.Please Login or Register to view this content.
Bookmarks