Hi Neil,

The AllowFormattingCells parameter is not available in xl2k.

---
Regards,
Norman


"Neil" wrote in message
...
I have a sheet that is designed in 2003 and works perfectly, I've mailed a
copy to a friend who has 2000 and he cannot get it to work because one of
the
macros trips up. The line that causes the problem is

ActiveSheet.Protect AllowFormattingCells:=True, Password:="BabyLaMaf"

Anyone got any ideas why this doesn't work in 200o, cos I've been looking
for clues for hours and getting no where fast!

Thanks in advance

Neil