![]() |
Copy/Move Worksheet from one Workbook to another
Guys, I have different 8 workbooks each having one worksheet inside it. I want to copy these all workbooks in another workbook as a summary of whole project. Unfortunately when i right click on sheet tab, all options are siable and i can't Copy/Move these worksheets. (Some of formulas are interlinked with oneanother worksheets). I tried my best but unable to locate problem. Kindly help me out. Its urgent Regards Qurrat Engineering Associates Karachi, Pakistan |
Copy/Move Worksheet from one Workbook to another
I'd look to see if the workbook is protected:
Tools|protection|Unprotect workbook (you may need to supply a password to unprotect it) Anney wrote: Guys, I have different 8 workbooks each having one worksheet inside it. I want to copy these all workbooks in another workbook as a summary of whole project. Unfortunately when i right click on sheet tab, all options are siable and i can't Copy/Move these worksheets. (Some of formulas are interlinked with oneanother worksheets). I tried my best but unable to locate problem. Kindly help me out. Its urgent Regards Qurrat Engineering Associates Karachi, Pakistan -- Dave Peterson |
Copy/Move Worksheet from one Workbook to another
Dear Dave,
I tried to unprotect sheet, but its asking for a password. I am unable to define password, tell me how can i unprotect it. I also tried to run passwordbreaker macro, but still unable. Guide me what i do?? Regards, Qurrat "Dave Peterson" wrote: I'd look to see if the workbook is protected: Tools|protection|Unprotect workbook (you may need to supply a password to unprotect it) Anney wrote: Guys, I have different 8 workbooks each having one worksheet inside it. I want to copy these all workbooks in another workbook as a summary of whole project. Unfortunately when i right click on sheet tab, all options are siable and i can't Copy/Move these worksheets. (Some of formulas are interlinked with oneanother worksheets). I tried my best but unable to locate problem. Kindly help me out. Its urgent Regards Qurrat Engineering Associates Karachi, Pakistan -- Dave Peterson |
Copy/Move Worksheet from one Workbook to another
Talk to the originator and ask him or her for the password. If he/she doesn't
want to give it to you, maybe there's a good reason. Anney wrote: Dear Dave, I tried to unprotect sheet, but its asking for a password. I am unable to define password, tell me how can i unprotect it. I also tried to run passwordbreaker macro, but still unable. Guide me what i do?? Regards, Qurrat "Dave Peterson" wrote: I'd look to see if the workbook is protected: Tools|protection|Unprotect workbook (you may need to supply a password to unprotect it) Anney wrote: Guys, I have different 8 workbooks each having one worksheet inside it. I want to copy these all workbooks in another workbook as a summary of whole project. Unfortunately when i right click on sheet tab, all options are siable and i can't Copy/Move these worksheets. (Some of formulas are interlinked with oneanother worksheets). I tried my best but unable to locate problem. Kindly help me out. Its urgent Regards Qurrat Engineering Associates Karachi, Pakistan -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 10:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com