Hided formulas appearing with copy/paste

  • Thread starter Thread starter LuisF
  • Start date Start date
L

LuisF

Is there a way to prevent copying hiden&protected formulas (cells) on
form ?.
When copy/paste (on a different worksheet) is used all the formula
appear on, you need only to select the range where the hiden formula
are.
Because the files may have different names it is impossible to link th
formulas to a base
 
If I did Format|Cells|Protection tab and made my formula cells Hidden and
locked, then after I protected the worksheet (tools|Protection|Protect sheet),
when I copied those formulas and pasted to another worksheet, they were pasted
as values.

(Did you remember to protect the worksheet?)

That said worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.

If you really think that you need to protect the formulas, you may want to
consider a different application. Excel isn't that secure.
 
Back
Top