How to Determine if in Draw Mode?
Hey All,
I was wondering if there is a way to determine when Excel is in draw mode (i.e. click on the 'Select Objects' arrow on the Drawing toolbar)? Thanks, TC |
How to Determine if in Draw Mode?
Not sure exactly what you are asking, but if you select an item like the
arrow from the drawing toolbar and the cursor turns into a tiny plus or crosshair, then it is in drawing mode. "TC" wrote: Hey All, I was wondering if there is a way to determine when Excel is in draw mode (i.e. click on the 'Select Objects' arrow on the Drawing toolbar)? Thanks, TC |
How to Determine if in Draw Mode?
Yes, but how to determine this programmatically using VBA?
"JLGWhiz" wrote in message ... Not sure exactly what you are asking, but if you select an item like the arrow from the drawing toolbar and the cursor turns into a tiny plus or crosshair, then it is in drawing mode. "TC" wrote: Hey All, I was wondering if there is a way to determine when Excel is in draw mode (i.e. click on the 'Select Objects' arrow on the Drawing toolbar)? Thanks, TC |
How to Determine if in Draw Mode?
Maybe...
If Application.CommandBars("Drawing") _ .Controls("Select Objects").State = msoButtonDown Then MsgBox "It's depressed" Else MsgBox "it's not depressed" End If TC wrote: Hey All, I was wondering if there is a way to determine when Excel is in draw mode (i.e. click on the 'Select Objects' arrow on the Drawing toolbar)? Thanks, TC -- Dave Peterson |
How to Determine if in Draw Mode?
Hey Dave,
I'm sitting here smiling because I've been fiddling with the CommandBars myself for the past 1/2 hour. Agreed... I think that this is the way to go. Thanks, Todd "Dave Peterson" wrote in message ... Maybe... If Application.CommandBars("Drawing") _ .Controls("Select Objects").State = msoButtonDown Then MsgBox "It's depressed" Else MsgBox "it's not depressed" End If TC wrote: Hey All, I was wondering if there is a way to determine when Excel is in draw mode (i.e. click on the 'Select Objects' arrow on the Drawing toolbar)? Thanks, TC -- Dave Peterson |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com