LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I execute a macro right after the user clicks the validation drop down? Michael[_44_] Excel Programming 1 December 23rd 06 08:05 PM
Creating a macro that simulates some of the toolbar button Duangruthai New Users to Excel 1 April 22nd 06 12:12 AM
Demonstrating mouse clicks with Macro JEFF Excel Programming 4 July 6th 05 04:04 AM
controlling another application via VBA code in Excell & sending keystrokes & mouse clicks Zaidan Excel Programming 0 June 6th 04 09:06 PM
Plot where mouse clicks Leo Excel Programming 1 November 14th 03 02:50 PM


All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"