Is there a way for me to delete all sheets in a workbook by vba except sheet 1??? I know how to do it if they always keep the same name but the names of the other sheets are not always the same... I want like a select all except sheet 1... Any help is appreciated. Oh, Also, how can i make it bypass that message that says "all sheets will be deleted blah blah..."?? Thanks!