I am trying to troubleshoot a spreadsheet that uses one worksheet as a user form and another worksheet as the report form. The form worksheet is positioned at the top and basically consists of some command buttons to run the report worksheet for a specific day, print the report, and close the report. The report worksheet sits directly below the form worksheet. Both are sized to take up the entire width of the excel application window.
I have not been able to get the code to resize my windows to work correctly. Here is the code that I am working with. I have been getting an error when attempting to set the width. The error states that it is unable to set the width property of the window class.
ActiveWindow.WindowState = xlNormal
ActiveWindow.Width = 768.75
ActiveWindow.Height = 122.75
ActiveWindow.Top = 1.75
ActiveWindow.Left = 1.75
okTabs = True
I will also attach the entire spreadsheet. Thanks in advance.