Resize Image To Excel Window Size And Scale To Fit Automatically

[Excel Fox]

Welcome to ExcelFox jjfletcher

What you have asked for is very much possible. There may be ways to hook the window using APIs, however if you want to do this using native VBA features in Excel, you will need to use Excel 2013 or above. The code below is just a sample to show you how this can be done in a rudimentary yet very effective way.

Private Sub Workbook_WindowResize(ByVal Wn As Window)
    
    With ThisWorkbook.Sheets(1).Shapes(1)
        .Width = Wn.VisibleRange.Width
        .Height = Wn.VisibleRange.Height
    End With
    
End Sub