Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel does not execute a button's code when another macro simulates mouse movements & clicks
Hi all-
I have a button, named Button1, on a worksheet. I have a macro which does several actions, including moving the mouse cursor over Button1 & simulating a mouse_down & mouse_up. I use SetCursorPos() and mouse_event() for this. I find that Button1's code does not execute when its click is simulated within another macro. Calling Button1_click() directly is not an option because the Button1_click code is in a password protected macro which I cannot view. The end goal is to be able to have the macro do something like this: 1) copy A1's value to A2 2) simulate Button1 being clicked 3) After Button1 is done (known to be < 1minute), copy A3's value to A4 Does anyone know a fix or workaround for any part of this? Thank you! Zachary harrison |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I execute a macro right after the user clicks the validation drop down? | Excel Programming | |||
Creating a macro that simulates some of the toolbar button | New Users to Excel | |||
Demonstrating mouse clicks with Macro | Excel Programming | |||
controlling another application via VBA code in Excell & sending keystrokes & mouse clicks | Excel Programming | |||
Plot where mouse clicks | Excel Programming |