XL2003: Toggling "Extend" Mode with VBA

[Conan Kelly]

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

 

[Dave Peterson]

I could hit the Escape key to turn it off.

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