I use the following code to delete new sheets and only keep the original when the workbook is saved. I'd like to apply the same idea to a workbook with multiple worksheets, but I can't get the syntax right. How would I delete worksheets not named Sheet1, Sheet2, etc?
Please Login or Register to view this content.
[i]Thanks!![/]
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi philbin,
I'd do this problem using the following code in a Module.
I'd call the code from:Please Login or Register to view this content.
See the attached example.Please Login or Register to view this content.
OnClose Delete Sheets.xlsm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Yup! Works perfectly. Thanks so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks