Can I oped Edit Filter screen using VBA ?

S

Smugliy

I can run filters() to open filter list in project ,but can I open edit
filter screen also using VBA ?

Thanks ?
 
R

Rod Gill

That's all that's available, but you could use the sendkeys method to send
some keystrokes to the keyboard buffer to open edit mode. Note however that
this has risks. If someone swaps to another application at just the wrong
time, those keystrokes get used by the new application with possibly very
undesirable results!!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
J

John

Smugliy said:
This is only open filters screen ,no edit filter screen
Click to expand...

smugliy,
I've got what I think is a better alternative. Since you're using VBA
already, why not set up the filter using the FilterEdit Method. Then you
don't need a filter edit window.

Hope this helps.
John
Project MVP
 
Top