Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Object Button
I am using Excel 2000. Near the bottom left corner is the Select Object
button with the arrow cursor icon. Can this button be toggled on and off using VBA code? If so, how? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Object Button
I think this will work (I don't have XL2000, but it works in my copy of
XL2003)... Sub ToggleSelectObject() Dim ctl As Object For Each ctl In CommandBars("Drawing").Controls If ctl.ID = 182 Then ctl.Visible = Not ctl.Visible End If Next ctl End Sub Rick "pan65" wrote in message ... I am using Excel 2000. Near the bottom left corner is the Select Object button with the arrow cursor icon. Can this button be toggled on and off using VBA code? If so, how? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Object Button
I read the "toggle on and off" part of your question as asking to make the
button visible or invisible. I see Peter T read your question differently. You might have to clarify for us exactly what you are looking for. Rick "Rick Rothstein (MVP - VB)" wrote in message ... I think this will work (I don't have XL2000, but it works in my copy of XL2003)... Sub ToggleSelectObject() Dim ctl As Object For Each ctl In CommandBars("Drawing").Controls If ctl.ID = 182 Then ctl.Visible = Not ctl.Visible End If Next ctl End Sub Rick "pan65" wrote in message ... I am using Excel 2000. Near the bottom left corner is the Select Object button with the arrow cursor icon. Can this button be toggled on and off using VBA code? If so, how? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Object Button
If you mean toggle up/down simply
CommandBars.FindControl(ID:=182).Execute or with a bit more control Sub Toggle182(nState As Long) Dim ctr As CommandBarButton Set ctr = Application.CommandBars.FindControl(ID:=182) If ctr.State < nState Then ctr.Execute End If End Sub Sub test() Toggle182 msoButtonDown ' -1 Stop Toggle182 msoButtonUp ' 0 End Sub Regards, Peter T "pan65" wrote in message ... I am using Excel 2000. Near the bottom left corner is the Select Object button with the arrow cursor icon. Can this button be toggled on and off using VBA code? If so, how? Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Object Button
Thanks that was exactly what I was looking for.
"Peter T" wrote: If you mean toggle up/down simply CommandBars.FindControl(ID:=182).Execute or with a bit more control Sub Toggle182(nState As Long) Dim ctr As CommandBarButton Set ctr = Application.CommandBars.FindControl(ID:=182) If ctr.State < nState Then ctr.Execute End If End Sub Sub test() Toggle182 msoButtonDown ' -1 Stop Toggle182 msoButtonUp ' 0 End Sub Regards, Peter T "pan65" wrote in message ... I am using Excel 2000. Near the bottom left corner is the Select Object button with the arrow cursor icon. Can this button be toggled on and off using VBA code? If so, how? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select next object | Excel Programming | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
automatically select object references | Excel Programming | |||
Can't select macro button after other button is pressed | Excel Programming | |||
Highlight/Select contents of object with focus | Excel Programming |