Code looping somewhere & freezing up workbook?

Good day all,

The code below works perfectly when run on the active sheet ("Page4+") but when run outside of the active sheet it freezes up my workbook, Does anyone have any ideas why the code might be causing the program to freeze up & if so how to clean it up? Thanks in advance.

Please Login or Register  to view this content.

P.S. Or maybe an alternative code for copying a "namedrange" from a checkbox & deleting that same range if unchecked?
Note: This post can also be found on Excelguru.ca - Marco