View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default 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")