Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MODE calc where more than one mode number! | New Users to Excel | |||
Determine Workbook Mode | Excel Programming | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |