Maximising window

[AndyMcC]

I am devising an Excel routine which requires approximately 50 variables to be entered for each calculation. The variables are stored on an Access database and I use an Access form to input these. The bulk of the work is done withing Excel, and those using the routine will be most familiar, and therefore most comfortable, with this application.
My problem is that when I swap from the full page Excel page to the Access one, the Access window is not full screen. Obviously it can be maximised in the top corner, but is there any way of ensuring that this is unnecessary?

 

[NateO]

Hello, not sure why you're flipping as you describe, but the following just about ought to do it:

Public Declare Function ShowWindow& Lib "user32" _
    (ByVal hwnd As Long, ByVal nCmdShow As Long)

Sub jkdsfk()
Call ShowWindow(Application.hWndAccessApp, 3)
End Sub