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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Sorting and filtering text 0
Is there any place I can get screen shots of Outlook Web Mail screens with notations? 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Can I use Microsoft Launcher with iPhone? 0
Presentation on 2nd screen without presenter view 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Can I edit macro buttons on the quick access toolbar in excel? 0

Top