A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
To resize the window you should only have to move the pointer to one of the edges of the window. When the pointer assumes this appearance drag the edge l/r or up/dn depending on which edge. Use the Title Bar to drag the window to a different location.
Insert a Module by going to Insert> Module in the menu bar or by using the Insert Module tool at the left end of the Ribbon Most of the tools are inactive unless a Module window is open.
Close the window by clicking the red stoplight n=button or just use the View Excel tool at the left of the Insert Module tool. You can go to Close & return to Excel in the Excel menu bar.
If you have a problem doing so please explain in detail Be sure to include the present Version Numbers of your Office software & macOS. Also, when did you last restart the Mac? Is the problem in one specific workbook or in all?