protected sheets

  • Thread starter Thread starter Hef
  • Start date Start date
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.
 
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.
 
Back
Top