If the paste-to range is unprotected you can paste into that range.
By default all cells on a sheet are locked when the sheet is protected.
CTRL + a(twice in 2003) to select all cells.
Format>Cells>Protection. Uncheck "locked" and OK
Now select the sections/rows/cells to protect and Format>Cells>Protection.
Check "locked" and OK
Tools>Protection>Protect Sheet
The section/row locking does not work if you don't protect the sheet.
Gord Dibben MS Excel MVP
I have a protected worksheet. How could I copy and paste within the
same worksheet without unprotect it? Any help will be highly
appreciated!
Gord Dibben MS Excel MVP