of course
1) from A6 down, so there is data above which should not be erased, but why limited to A999? Is there data below? if not then I would propose to delete everything down from A6.
- above A6 is data and no hyperlinks to sheets? --> then the destination address has to be change to "A6"
2) there is a workbook event that can trigger the macro
But if you afterwards rename a worksheet then you have to trigger it manually.
I have found something on the internet but this means you have to add the class to the workbook and additionally the function Worksheet_Activate() on every sheet
https://stackoverflow.com/questions/...event-in-excel
Bookmarks