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

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

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

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