It is an Excel function that if you zoom below 40%, named ranges (if they are more than one cell) appear on the sheet. I think the only way to prevent that is to set the Visible property of the names to False.