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

On Mon, 3 Aug 2009 21:25:54 +0100, "Bill R"
wrote:

"epc.steff" wrote in message
...
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