Protection in Excel 2002 not works for <2002 1

[xlStar]

Hello there.

This VBA scripts in Excel 2002 doesn't seems to work for people with Excel 2000 or earlier.

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingRows:=True, AllowFiltering:=True

How can I overcome this, i.e the user should be allows to use the AutoFilter but I can't find a way to make the VBA adaptable for both Excel 2000 and 2002.

 

[SkipVought]

Hi,

There have been changes in the Protection Object between versions. Some properties are NOT backward compatable.

Check

http://www.microsoft.com

for version changes.

Skip,

_[red][/red]