Application.Undo Problem
 

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

--
Message posted from http://www.ExcelForum.com

Application.Undo Problem
 

Prasad,

You need:

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

HTH,
Bernie
MS Excel MVP

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

Prasad Joshi


---
Message posted from http://www.ExcelForum.com/