SendKeys not working for displaying filter dropdown list in excel 2007

I have problems using SendKeys in Windows 7 also, with applications that worked in Vista or XP. When I turn UAC off (not recommended) SendKeys works for me in Windows 7.

To enable and disable UAC in Windows 7 see:
http://www.howtogeek.com/howto/windo...windows-vista/

Lewis

Thank you Lewis.

My case is that my UAC is already set to "never notify". So it's not the reason why it doesn't work, i think.
By the way, the macro works also for other normal cells to display a dropdown of data of previous rows, same as I manually press Alt+down.
I can also manually press Alt+down to show the dropdown filter. However, it just blinks once if I use macro on filter cell.

Originally Posted by LJMetzger

I have problems using SendKeys in Windows 7 also, with applications that worked in Vista or XP. When I turn UAC off (not recommended) SendKeys works for me in Windows 7.

To enable and disable UAC in Windows 7 see:
http://www.howtogeek.com/howto/windo...windows-vista/

Lewis

I only occasionally have access to Windows 7, and use Excel 2003 almost exclusively. I've been researching the problem for my own use, and found the following links which may be useful. I have not tried any of the techniques in the links yet.

About halfway down in the following link there is a code snippet that uses 'keybd_event ()':
http://social.msdn.microsoft.com/For...elopmentissues

The following discusses 'keybd_event ()':
http://www.excelforum.com/excel-prog...ybd_event.html

The following uses 'PostMessage()':
http://fracta.net/fracta/index.php/f...ll-postmessage

The following may be slightly off topic, as it traps keystrokes and attempts to echo the results:
http://stackoverflow.com/questions/1...editing-a-cell

I hope these help.

Lewis