I am trying to run a Macro at startup that will close a previous linked workbook (named MainMenu). I have the following code:

Code:
Private Sub Workbook_Open()
Sub CloseMainMenu()
Windows("Filename.xlsm").Activate
    ActiveWindow.WindowState = xlNormal
    ActiveWindow.Close

End Sub
If I leave as is, I receive Compile Error: expected end sub with the first line.
If I remove...