Dear CLR,
Thank you for your response. But I want to copy from excel to word, Then
what should i do?

"CLR" wrote:

=Sheet1!A1 will return the value in sheet 1 cell A1 whether Sheet 1 is
protected or not. It can be copied to adjacent cells to expand the range.

It can also be used in formulas, like =SUM(Sheet1!A1,Sheet1!A2)

hth
Vaya con Dios,
Chuck, CABGx3



"Rao Ratan Singh" wrote:

Hi all,
Is there any way to copy a specific range from protected worksheet. Because
I have formulas in this sheet. when i copy a specific range it may be delete
or currupt.

so pls give me a solution.

Rao Ratan Singh