Warn if Cell/Column/Row Contains a Range Name
 

Is there a way to have a msgbox pop up whenever you are trying to delete a
range that contains a range name? If so, can it also provide the affected
cell address(es)? If not, is it possible to even get a warning after the
fact that you just deleted a range name?

Warn if Cell/Column/Row Contains a Range Name
 

This is very hard to do. To begin with, you can't catch the fact that a row
or column is deleted.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Paige" wrote:

Is there a way to have a msgbox pop up whenever you are trying to delete a
range that contains a range name? If so, can it also provide the affected
cell address(es)? If not, is it possible to even get a warning after the
fact that you just deleted a range name?

Warn if Cell/Column/Row Contains a Range Name
 

Thanks!

"Wigi" wrote:

This is very hard to do. To begin with, you can't catch the fact that a row
or column is deleted.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Paige" wrote:

Is there a way to have a msgbox pop up whenever you are trying to delete a
range that contains a range name? If so, can it also provide the affected
cell address(es)? If not, is it possible to even get a warning after the
fact that you just deleted a range name?