Sheets ("").Copy not working

  • Thread starter Thread starter Ron McCormick
  • Start date Start date
R

Ron McCormick

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
 
Ron said:
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.
Click to expand...

Tools / Protection / Unprotect Workbook ?

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