Hi

I've written a sheet that performs some locic checks, and written code to "roll forward" the sheet (i.e. increase the years by 1, replace the brought forward figures with the carried forward figures etc), and attached it to a command button embedded in the sheet.

When the sheet rolls forward, it copies itself and creates a back up sheet. However, it also copies the command buttons that are embedded into the sheet. Does anyone know to delete the command buttons from the duplicate sheet?

Also - does anyone one know how to prevent the command buttons from printing?

One final thing - is it possible to automatically set the print margins to fit all the data on the sheet onto one page

Thanks in advance

Charlie