Whatever you go with, you will need code at the beginning to unprotect the
sheet, then code at the end to protect the sheet again (or you could do these
steps yourself before and after running the macro).

ActiveSheet.Unprotect Password:="password"

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, _
Scenarios:=True, Password := "password"



"Kel" wrote:

Hi all and thanx again for sharing your great knowledge with others,

Im looking to do the following it should be as a macro in VB on a sheet
which is protected and with a password,

if say AND(D1 is less then zero (0) delete contents from entire row,
D2 less then zero delete contents from entire row, and same on D3 and so on,

so the macro will search the entire sheet in column D, if cell in D column
is less then 0 delete contents from entire row.

Thanx again