Forum Discussion
PROTECTING CELLS BUT ALLOW COPYING OF ROWS
Hi Gurus I have a spreadsheet where I have protected the sheet with password, said to allow select locked and also insert rows, but I want users to be able to copy rows and then insert with the form...
visit these sites:
https://support.office.com/en-us/article/copy-and-paste-in-a-protected-worksheet-139e676e-10a0-443b-bbfe-3dac22cd8476
https://www.extendoffice.com/documents/excel/4129-excel-protect-sheet-allow-copy.html
another way is in Workbook_open sub - unprotect the sheet
then in Workbook_BeforeClose sub - protect the sheet
HTH
Thanks Lorenzo - I've already looked at the first link - so I'll have a look at the second. P