Forum Discussion

aekbus's avatar
aekbus
Brass Contributor
May 28, 2026

Names in Excel Name Manager

I have a spreadsheet ( I will call it spreadsheet "A") driven by macros that creates a new worksheet each month.  I am developing a second spreadsheet I will call it spreadsheet "B") that links to it for a monthly summary.  I have given all the cells names that are to be linked.  The issue I am dealing with is when a new monthly tab is created on "A", I want the links  from "B"  to be updated to the new month.  The approach I am taking is to delete all of the names in "A" and recreate them for the new month.  (The reason I want to delete the older names is because over time, the Names list would grow into a very large list of obsolete names). The problem I am encountering is that when a name is deleted, a dialog box appears that the user has to acknowledge that, Yes, I want to delete this name.  I want to make this process transparent to the user.

So, my question is: Can I delete a name without generating this dialog box?

No RepliesBe the first to reply