About Us

pan65

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select next object	Mike	Excel Programming	4	May 2nd 06 02:54 PM
Option button object proeprties or object not found in vba	Pete Straman S via OfficeKB.com	Excel Programming	0	August 31st 05 05:49 PM
automatically select object references	Job	Excel Programming	0	February 3rd 05 09:41 PM
Can't select macro button after other button is pressed	C. Campbell	Excel Programming	1	November 30th 04 07:46 PM
Highlight/Select contents of object with focus	andy[_5_]	Excel Programming	2	January 15th 04 02:44 PM

Menu

About Us