| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| How do I remove the "Page 1" watermark from my working copy | New Users to Excel | |||
| Sheets("Rpt").Copy different results from running in macro than off excel menu?? | Excel Discussion (Misc queries) | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
| Working out age from "Day" "Month" "Year" | Excel Worksheet Functions | |||
![Ron McCormick[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
