any sugestions on how to edit the code to get a "backup" of the workbook
writen in to the code just after the user choose yes to clear the workbook
but before clearing.

my gues would be that by save as i interupt the code. but whats my
alternatives?