I never have.

So I'm glad lhad answered!

Jim Rech wrote:

How do you run that macro when you're in edit mode, Dave? Aren't macros
disabled then? The only way I recall "achieving" that was with a Windows
API callback ontime function. I think it crashed Excel<g.

--
Jim
"Dave Peterson" wrote in message
...
|I call it edit mode.
|
| Jan Karel Pieterse posted this. I think it should work in xl2003 and
below.
| I'm not sure what you'd check in xl2007's ribbon.
|
|
| When XL is in editing mode, certain menu items are disabled. You could
check for
| the enabled property of them.
|
| E.g.:
|
| Sub Editing()
| If Application.CommandBars(1).FindControl(ID:=23, _
| recursive:=True).Enabled = False Then
| MsgBox "Editing"
| Else
| MsgBox "Not editing"
| End If
| End Sub
|
|
| =========
| Maybe you can check that status before your code does anything.
|
|
|
| lahd wrote:
|
| No ideas from anyone? Really? Not even help with the language? What
do you
| call the state of the system when the user is in the middle of editing a
cell?
|
| --
|
| Dave Peterson

--

Dave Peterson