Forum Discussion

Brass Contributor

May 28, 2026

Solved

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...

excel

Macros and VBA

MKoski
Jun 02, 2026
Yes there is...
I have VBA which goes thru that deletes and adds naming...
use the code "Application.DisplayAlerts = False" at the top of the coding and on exit of the programing use "Application.DisplayAlerts = True". I expect it should also work on the "ThisWorkbook" doing something like (though it would end messages until you reset it within "Private Sub Workbook_BeforeClose(Cancel As Boolean)" or "Private Sub Workbook_Deactivate()" or simuliar.)
Private Sub Workbook_Activate()
Application.DisplayAlerts = False
end sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = True
end sub

MKoski

Brass Contributor

Jun 02, 2026

Yes there is...

I have VBA which goes thru that deletes and adds naming...

use the code "Application.DisplayAlerts = False" at the top of the coding and on exit of the programing use "Application.DisplayAlerts = True". I expect it should also work on the "ThisWorkbook" doing something like (though it would end messages until you reset it within "Private Sub Workbook_BeforeClose(Cancel As Boolean)" or "Private Sub Workbook_Deactivate()" or simuliar.)

Private Sub Workbook_Activate()

Application.DisplayAlerts = False

end sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.DisplayAlerts = True

end sub