Tile an excel window and stay open while editing another program

Ajunk

New Member
Joined
Oct 19, 2016
Messages
19
Ok, I have some basic code that resizes and repositions an excel workbook.

It does this so the user (me) can view the worksheet and enter the data from that worksheet into another program.

I recorded a the following macro and it works great:
Code:
    Application.WindowState = xlNormal
    Application.Left = 761.5
    Application.Top = 81.25
    Application.Width = 445.5
    Application.Height = 390
    Application.Left = 862
    Application.Top = 47.5
   End Sub

However, whenever I click or use the other program it closes the excel window.
My goal is to leave this open so I can view the sheet and enter the data from it into another program - without a lot of extra clicking around.
In addition, 4 other users will be using this sheet, so I'm hoping to make it a simple as possible. I have very little knowledge of VBA, and the other users have none.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top