Sheets ("").Copy not working
 

I have a procedure which involves copying worksheets
within a file. I am still working on the relevant
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.

Has anyone got any thoughts as to what might be causing
this?

TIA
Ron

Sheets ("").Copy not working
 

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