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:
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.
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.