Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not sure where would be most appropriate group (or online forum) in
which to post this obscure query. But, although it's slightly OT here, I though maybe someone might have seen similar behaviour when writing Excel macros? For background, I'm trying to write a macro to repeat a series of tedious operations in Windows Movie Maker. Not with Excel VBA, but using Macro Express, although that seems irrelevant to the actual problem. The first step of the macro is to r-click a button to bring up its context menu. To limit my macro entirely to keystrokes, with no mouse operations, I'm using the equivalent Shift+F10. The frustrating thing is that *sometimes* manually keying Shift+F10, with the button selected, just doesn't work! So obviously the macro doesn't work reliably. And, after the first failure, it continues to fail. Instead of bringing up the button's context menu, it brings up the context menu for the surrounding area. IOW, it acts as if the button wasn't selected. But as soon as I use a mouse r-click instead, that immediately opens the correct context menu. Exasperating! Anyone with any thoughts on possible causes please, or on appropriate groups/forums to enquire? Movie Maker is itself a bit flaky in some areas, so I suspect maybe this is unique to that application. But I'd be interested to hear of any other instances in which Shift+F10 doesn't deliver. -- Terry, West Sussex, UK |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Terry Pinnell wrote:
Not sure where would be most appropriate group (or online forum) in which to post this obscure query. But, although it's slightly OT here, I though maybe someone might have seen similar behaviour when writing Excel macros? For background, I'm trying to write a macro to repeat a series of tedious operations in Windows Movie Maker. Not with Excel VBA, but using Macro Express, although that seems irrelevant to the actual problem. The first step of the macro is to r-click a button to bring up its context menu. To limit my macro entirely to keystrokes, with no mouse operations, I'm using the equivalent Shift+F10. The frustrating thing is that *sometimes* manually keying Shift+F10, with the button selected, just doesn't work! So obviously the macro doesn't work reliably. And, after the first failure, it continues to fail. Instead of bringing up the button's context menu, it brings up the context menu for the surrounding area. IOW, it acts as if the button wasn't selected. But as soon as I use a mouse r-click instead, that immediately opens the correct context menu. Exasperating! Anyone with any thoughts on possible causes please, or on appropriate groups/forums to enquire? Movie Maker is itself a bit flaky in some areas, so I suspect maybe this is unique to that application. But I'd be interested to hear of any other instances in which Shift+F10 doesn't deliver. No one with any thoughts on this please? -- Terry, West Sussex, UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Value from Table erratic | Excel Worksheet Functions | |||
Erratic display of concatenation | Excel Worksheet Functions | |||
Automatic Completion Erratic | Excel Discussion (Misc queries) | |||
erratic listbox behavior | Excel Programming | |||
Erratic Behaviour of Buttons | Excel Programming |