protected sheets

H

Hef

How can I export data from a protected worksheet into a
new sheet without unprotecting original sheet. I need to
keep the data protected because of all the formulas
involved, but I want others to be able to work with
results in another sheet.
 
E

Earl Kiosterud

Hef,

You can use Copy/Paste into a new sheet. If cells containing formulas are
set as Hidden (Format - Cells - Protection), then you'll get the value from
the formula, not the formula.
 

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

Copying cells in a protected worksheet 2
Protect and Edit Object 1
Protecting is NOT working right !!!!!!!!!!!!!! 6
Insert/ delete row in protected worksheet 7
edit a comment while protect sheet is on the cell is unprotected 1
To protect all worksheet simultaneously in a excel workbook 1
How do I put a formula into an unlocked cell on protected workshee 1
how to hide rows in a protected sheet 7

Top