Protected worksheet - Insert columns/rows

R

Rich

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!!
 
D

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.
 
Top