Forum Discussion
Worksheet Protection
You won't be able to paste entire rows in a protected sheet if one or more columns are locked. Allowing it would be dangerous because would enable users to overwrite the formulas in the locked columns with formulas of their own.
You might provide a macro that duplicates a row to the row below it, for example. You'd have to unprotect the sheet at the beginning of the macro, and to reprotect it at the end.
You won't be able to paste entire rows in a protected sheet if one or more columns are locked. Allowing it would be dangerous because would enable users to overwrite the formulas in the locked columns with formulas of their own.
You might provide a macro that duplicates a row to the row below it, for example. You'd have to unprotect the sheet at the beginning of the macro, and to reprotect it at the end.
- Sigh... I figured as much. I really did not want to use macros. Thanks for the very quick response!
