Application.Undo Problem

[pgjoshi]

I have used application.undo for avoiding deleting the formula fro
unprotected worksheet. It runs well with no errors. But when I try t
delete formula from a cell screen vibrates & take much time t
reposition. Also If I write a msg that "This is a formula You can'
Delete it" then it goes into loop & shows msg repeatedly. Please hel
me.

Prasad Josh

 

[Bernie Deitrick]

Prasad,

You need:

Application.EnableEvents = False
'your code
Application.EnableEvents = True

HTH,
Bernie
MS Excel MVP