Protection permissions

[epc.steff]

I have a worksheet that I have password protected but want to allow users to
delete rows. The 'delete rows' box is checked when protected but will not
allow users to delete. Any suggestions?

 

[Bill R]

I have a worksheet that I have password protected but want to allow users
to
delete rows. The 'delete rows' box is checked when protected but will not
allow users to delete. Any suggestions?

"Microsoft has added password protection capability to many features in
Office to help prevent unauthorized access to important information." In
other words it works on trying to open a file. It has nothing to do with
what may be done to the file once it is open. For that you need to look
elsewhere.

Bill R

 

[Gord Dibben]

If ANY cell in the row to delete is locked, you cannot delete the row even
after "allowing" row deletion.

If that meets your situation you must code to unprotect, delete then
re-protect.

ActiveSheet.Unprotect
Selection.Delete Shift:=xlUp
ActiveSheet.Protect AllowDeletingRows:=True

Of course you must add any other functions you want allowed when
re-protecting.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Bill

Have a look at Excel help under workbook and worksheet protection.

There are several types of protection.........only one of which is "file
open" protection that you refer to.


Gord Dibben MS Excel MVP