Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2003: "Auto row height" with Wrap Text driving me nuts | Excel Discussion (Misc queries) | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
Toggling between a macro running a "Form" and Excel | Excel Programming | |||
XL2003 "paste method of worksheet class failed" | Excel Programming |