Copy/Move Worksheet from one Workbook to another

A

Anney

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
 
D

Dave Peterson

I'd look to see if the workbook is protected:

Tools|protection|Unprotect workbook
(you may need to supply a password to unprotect it)
 
A

Anney

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extract email addresses from 1 worksheet to another workbook 19
Move/Copy Worksheet with Macros 2
Combine multiple workbooks into one workbook 3
Copy Worksheet to another Workbook 5
Copy formula from one workbook to another without reference to 1st 4
Cannot copy worksheet within one workbook 4
Move & Copy Problem, Limit? 3
Copying template from one worksheet to another 2

Top