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

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

The enriched protection options were introduced in Excel 2002 and later, so
xl2000 does not support that option.

--
Regards,
Tom Ogilvy

"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