Excel Copy Worksheet Does Not Work. So far we've worked with copying Sheets within a Workbook. What I want to do One Excel workbook is called as the source worksheet, where this link carries the worksheet data automatically, and the other workbook is called as the destination worksheet in which it With the help of formula, you can copy one Excel sheet to another and to do this just follow the steps Copy Worksheet to a Closed Workbook.
When working with worksheets, you can assign a worksheet to an object variable, and then use the variable instead of the worksheet references.
I am kind of lost now since I have deleted all worksheet and links from my Excel file and it still won't copy.
So how do you unprotect an Excel spreadsheet when you don't have the password? Thanks Gord, that does work! "Anne" wrote: > I want to use the move/copy worksheet function to copy a worksheet from one > workbook to another. But this quickly leads to a need to add worksheets to an existing workbook, not just creating one f.








