Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|