View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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