Link to home
Start Free TrialLog in
Avatar of Aaron Greene
Aaron GreeneFlag for United States of America

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.DisplayWorkbookTabs = True

I will also attach the entire spreadsheet.  Thanks in advance.
MON10---Primary-Disinfection.xls
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aaron Greene

ASKER

I think that using an actual user form is going to be the most direct answer to this.  Thanks.