XL2003: Toggling "Extend" Mode with VBA
 

Hello all,

Is there a way to toggle (or test if enabled) "Extend" mode with VBA?

I wanted to put a button on a toolbar to toggle extend mode so I could turn
it on/off with a mouse click.

I tried this...



Sub ToggleExtend()
Application.SendKeys "{F8}"
End Sub



....and it turned it on, but it won't turn it off.

Thanks for any help anyone can provide,

Conan Kelly



---------------------------
"Smokin' weed kills your brain cells. Drinkin' only screws up your
liver...ya got 2 a those."
- Earl Hickey (NBC's "My Name is Earl")

XL2003: Toggling "Extend" Mode with VBA
 

I could hit the Escape key to turn it off.

Maybe you could test that in a different macro???

Conan Kelly wrote:

Hello all,

Is there a way to toggle (or test if enabled) "Extend" mode with VBA?

I wanted to put a button on a toolbar to toggle extend mode so I could turn
it on/off with a mouse click.

I tried this...

Sub ToggleExtend()
Application.SendKeys "{F8}"
End Sub

...and it turned it on, but it won't turn it off.

Thanks for any help anyone can provide,

Conan Kelly

---------------------------
"Smokin' weed kills your brain cells. Drinkin' only screws up your
liver...ya got 2 a those."
- Earl Hickey (NBC's "My Name is Earl")

--

Dave Peterson