I know english is probably not your native language but your request is very confusing as your code does not match your description.
So, the application does not raise any events when resizing. Only changes in workbook windows are triggered. BUT the event does not happen if the resize is a result of the application resizing. This means if the workbook is maximized within the application and the application is resized no event happens.
this code changes the formula bar display based on window state, change false/true as required.
Private Sub Workbook_WindowResize(ByVal Wn As Window)
If Wn.WindowState = xlMaximized Then
Application.DisplayFormulaBar = False
ElseIf Wn.WindowState = xlMinimized Then
Application.DisplayFormulaBar = False
ElseIf Wn.WindowState = xlNormal Then
Application.DisplayFormulaBar = True
End If
End Sub
Bookmarks