Confirm before deleting a worksheet?

E

edeil

When deleting a worksheet, is there a setting in Excel 2003 where it will
prompt you whether you really want to delete the worksheet?

This feature was in previous releases of Excel but I haven't found it in 2003.

thanks.
 
D

Dave Peterson

If xl2003 thinks that the worksheet has been used, then you'll get the prompt.

I created a sheet.xlt template file and stored it in my XLStart folder. I just
wanted each new sheet to have a certain footer.

When I add a new sheet to an existing workbook, excel sees that sheet as "used"
and I get a prompt.

Maybe you could do the same thing.

I also have a workbook template named book.xlt in that same XLStart folder--with
the same footer info in each sheet. I get prompted when I try to delete any of
those sheets, too.
 
Top