- Feb 18, 2002
I have a workbook with 2 sheets in it. On one sheet is a Pivot Table based on an MSQuery. When a user double clicks data in the table, a new sheet is added with the details for that data point. Is there away to make this new sheet self delete before saving? I thought maybe looping through each sheet and deleting those not named correctly. Is that feasible?