Copy from Protected sheet

  • Thread starter Rao Ratan Singh
  • Start date
R

Rao Ratan Singh

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
 
C

CLR

=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
 
R

Rao Ratan Singh

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

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

Top