[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

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.
1 Solution
Rob HensonIT & Database AssistantCommented:
Tried opening the file but can't see what you are trying to do. Have you looked at using an actual User Form?

The form can be set to hover over the existing sheet but the sheet still has focus unless you click buttons on the User Form.

The Form can be set to Show on workbook open and its position can be programmed.

Rob H
AaronGreene1906Author Commented:
I think that using an actual user form is going to be the most direct answer to this.  Thanks.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now