Cut and Paste into spreadsheet with locked formulas
 

Hello,
I need to cut and paste into a spreadsheet where the formulas are locked. I
have selected Formatcellsprotection 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

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

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Oak" wrote in message ...
Hello,
I need to cut and paste into a spreadsheet where the formulas are locked. I
have selected Formatcellsprotection 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