clear contents vs delete

Greetings all,
I have a spreadsheet and on the spreadsheet I have many named ranges. I have quite a few sub routines on the worksheet change event

for example

cell b22 is named range vdom1
cell b23 is named range vdom2
cell b23 is named range vdom3
cell b24 is named range vdom4

I have a worksheet change event sub for each of the above that will hide or make visible other rows on other sheets. if I for example delete the contents of b22 then the worksheet change happens properly, same if I delete the contents of cell b23. If I select all of the cells and then clear contents it does not trigger the worksheet change events. I am going to asssume that the users will select all cells like above and say clear contents to start over. Is there some way to say that if a user selects multiple named range cells and then says clear contents that it will run the sub routines for those cells?

Below is one of the grouping of change events. And if I am on the page where they named range is at and select delete, then the change event is in fact triggered. it is just when I want to reset all named ranges by selecting them on the sheet, right clicking and then selecting clear contents.

I have attached a copy of the spreadsheet. The values I want to be able to clear contents of are in cells b29 through B31 or any combination of that. So I could just slect b30 through B31, right click and say clear contents. But then if you go to page named zone_Int_Conf you will see that the name portion is removed, but the cells are not hidden like they should be.

Please Login or Register  to view this content.