Dave 2006-07-31 13:36:04
Using VBA i want to make sure Autofilter is off before I run some other code.
I ran macro recorder and see that the command
toggles the autofilter on and off. The problem is I just want to turn it
off, so i can’t use this command if the autofilter is not on or it turns it
Is there some resource online or within help that describes the macro
commands and which qualifiers you can use with them (I tried “Autofilter off”
and “Autofilter False”, but it gives me errors).
Can anyone tell me how to use this command to switch autofilter off.
PS – sorry for the double post (also in general questions)
Rod gill rod a 2006-07-31 13:37:00
John hasn’t replied so he must be busy or away.
In Project 2003 the following works for me:
ActiveProject.AutoFilter = false
ActiveProject.AutoFilter = true
If ActiveProject.AutoFilter = False Then
If ActiveProject.AutoFilter = True Then
Visit www.msproject-systems.com for Project Companion Tools and more