Aaron Greene
asked on
Create a floating worksheet in excel
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
ActiveWindow.DisplayWorkbo okTabs = True
I will also attach the entire spreadsheet. Thanks in advance.
MON10---Primary-Disinfection.xls
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
ActiveWindow.DisplayWorkbo
I will also attach the entire spreadsheet. Thanks in advance.
MON10---Primary-Disinfection.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER