AllowFiltering vs EnableAutoFilter

  • Thread starter Thread starter Dave Unger
  • Start date Start date
D

Dave Unger

Hello,

With regard to Autofiltering on a protected sheet, can anyone tell me what the difference (if any) is between these 2 code segments?

ActiveSheet.Protect Contents:=True,Userinterfaceonly:=True,AllowFiltering:=True

or

ActiveSheet.Protect Contents:=True, Userinterfaceonly:=True
ActiveSheet.EnableAutoFilter = True

I seem to get the same results, using either one. Can't seem to find a definitive answer on any of the forums, etc.

Thank you,

Regards

Dave
 
Hello,
With regard to Autofiltering on a protected sheet, can anyone tell me
what the difference (if any) is between these 2 code segments?

ActiveSheet.Protect
Contents:=True,Userinterfaceonly:=True,AllowFiltering:=True

or

ActiveSheet.Protect Contents:=True, Userinterfaceonly:=True
ActiveSheet.EnableAutoFilter = True

I seem to get the same results, using either one. Can't seem to find
a definitive answer on any of the forums, etc.

Thank you,

Regards

Dave
Click to expand...

Your 1st implementation is a Worksheet.Protect parameter and was
introduced/added in XL2002.

The 2nd implementation is a Worksheet property, and is how this was
done in versions earlier than XL2002.

Using the 1st implementation raises an error if your project is run in
earlier versions. Since they both achieve the same thing, I use the 2nd
implementation only because I do not have to reset protection to turn
it off/on, and some clients still run XL2000.

Note, though, that some of the protection parameters do not persist
after closing the file. For example, if you use code to modify locked
cells on a protected sheet then protection must be removed and reset
for the 'UserInterfaceOnly' parameter to work.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Hi Garry,

Thanks for your reply.
Your 1st implementation is a Worksheet.Protect parameter and was
introduced/added in XL2002.

The 2nd implementation is a Worksheet property, and is how this was
done in versions earlier than XL2002.
Click to expand...

I kind of suspected it was a "version" thing, but couldn't seem to locate an authoritative answer.
Using the 1st implementation raises an error if your project is run in
earlier versions. Since they both achieve the same thing, I use the 2nd
implementation only because I do not have to reset protection to turn
it off/on, and some clients still run XL2000.
Click to expand...

I understand, makes sense to me.
Note, though, that some of the protection parameters do not persist
after closing the file. For example, if you use code to modify locked
cells on a protected sheet then protection must be removed and reset
for the 'UserInterfaceOnly' parameter to work.
Click to expand...

Right, I've run into that one!

Thanks again Garry, much appreciated.

Regards,

Dave
 
Back
Top