Ron McCormick wrote:
workbook and have added various bits of code. Suddenly
the Sheets("Sheetname").Copy bit of the procedure has
stopped working, and even if I try to copy a sheet
manually within the workbook it will still not work.


Tools / Protection / Unprotect Workbook ?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup