Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default double click macros

Hi

i have assigned macros to three oval objects
when you click on the first oval it turns it green and the other oval turn
grey
when you click on the second oval it turns it yellow and the other two turn
grey.
etc etc..

i wanted to somehow make it that when you double click on one of the ovals
that it
turn all three grey
i.e. reset them

please help

t
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,344
Default double click macros

Hi,

The problem here is that ovals don't have a double-click property and you
can only assign one macro to each oval.

Now if you replace the ovals with Control Toolbox command buttons you can
assign more than one macro to each button, because those buttons support
multiple event procedures.

--
Thanks,
Shane Devenshire


"T-bone" wrote:

Hi

i have assigned macros to three oval objects
when you click on the first oval it turns it green and the other oval turn
grey
when you click on the second oval it turns it yellow and the other two turn
grey.
etc etc..

i wanted to somehow make it that when you double click on one of the ovals
that it
turn all three grey
i.e. reset them

please help

t

Reply
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
double click macros jack[_2_] Excel Programming 2 September 27th 07 01:53 AM
double click macros Mike Excel Programming 0 September 26th 07 04:40 AM
double click macros Mike Excel Programming 0 September 26th 07 04:32 AM
double click macros Alok[_3_] Excel Programming 0 September 26th 07 04:27 AM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM


All times are GMT +1. The time now is 08:20 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"