Cut and Paste into spreadsheet with locked formulas

O

Oak

Hello,
I need to cut and paste into a spreadsheet where the formulas are locked. I
have selected Format>cells>protection and cleared the Locked checkbox for the
cells where I want to cut and paste. I can enter data OK but it will not
allow me to enter via cut and paste. Any ideas?
Thanks
 
D

David McRitchie

Record a macro turning protection off, do what you want in the macro, then turn
protection back on.

--
 
Top