test that there is something to undo before executing application.
This works ok in xl2003 in my USA/English version:
If Application.CommandBars("Standard").Controls("Undo ").Enabled = True Then
MsgBox "there's something to undo"
Else
MsgBox "nothing to undo"
End If
pwrob wrote:
hi, is there a way to test that there is something to undo before executing
an Application.Undo?
Thanks,
pwrob
--
xl help seeker
--
Dave Peterson
|