Protected worksheet - Insert columns/rows

[Guest]

Hi, Let me clarify. Any way to setup a worksheet so it is protected from
data or column/row deletions, but the user would be able to insert
columns/rows while the worksheet was "still" protected? Thanks!!

 

[Frank Kabel]

Hi
not possible without this kind of macro.

 

[Dave Peterson]

Maybe you could provide them with a macro that inserts columns/rows. Then with
the worksheet protected, they won't be able to delete rows/columns.

Your macro could unprotect the sheet, insert whatever you want, and then
reprotect the sheet.