How to Copy a Formatted Row into a Protected Sheet
How do I keep the data validation lists in a cell when these rows are added to a protected spreadsheet using "insert copied cells"?
My sheet must be updatable by multiple users. Originally, I protected the sheet to allow the additional rows only in the unprotected areas. However, when the sheet is protected, the "drop down" formatting is removed from the copied cells and the new rows lose their data validation constraints. If I remove the protection, the data lists copy but the cell widths (and therefore the sheet display) is corrupted when the other users change the cell width in the source rows.
How can I protect my spreadsheet from cell width changes AND allow users to insert rows that keep ALL their formatting, specifically data validation lists?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1