Book 1 is a blank worksheet with a large button in the middle entitled OPEN
The macro for this button is here
I've put the macro together by following advice on here and recording my own macro's and trying to piece them together, now I'm stuck.
Book1, Workbook 1 and Workbook 2 will be held together in the same folder. If possible I want workbook 1 and workbook 2 to be hidden files. With this is mind, and as the 2 sheets wil be held in the same folder as Book 1, is it possible to then remove the full location from the macro and just link to them based on Book 1 being in the same location (within a folder called Media Tools)?
I want to be able to open Workbook 1 and 2 together and split them on the screen. Ideally with Workbook 1 taking up 1/3 of the screen and Workbook 2 2/3 of the screen, but if I can only do 50:50 I'm happy to just accept that. I want Book 1 to close as it is merely a tool to open the other 2 spreadsheets.
The problem I am having is that when it arranges the spreadsheets it's including Book 1 in the vertical split as that instruction is there before the instruction to close.
I am also using a dual screen set up, I want the workbooks to open on the 2nd screen, the line 'Application.Left = 1150' opens the workbooks at the furthest point left of the second screen.
Any help would be most appreciated. I've probably gone about this completely the wrong way but I'm still trying to learn VBA etc.
Thanks in advance
The macro for this button is here
Sub Macro1()
'
' Macro1 Macro
'
'
Workbooks.Open Filename:= _
"C:\Users\Username\Desktop\Media\Workbook 1.xlsm"
Application.Left = 1150
Workbooks.Open Filename:= _
"C:\Users\Username\Desktop\Media\Workbook 2.xlsm"
Application.Left = 1150
Windows("Book1.xlsm").Activate
Windows.Arrange ArrangeStyle:=xlVertical
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
I've put the macro together by following advice on here and recording my own macro's and trying to piece them together, now I'm stuck.
Book1, Workbook 1 and Workbook 2 will be held together in the same folder. If possible I want workbook 1 and workbook 2 to be hidden files. With this is mind, and as the 2 sheets wil be held in the same folder as Book 1, is it possible to then remove the full location from the macro and just link to them based on Book 1 being in the same location (within a folder called Media Tools)?
I want to be able to open Workbook 1 and 2 together and split them on the screen. Ideally with Workbook 1 taking up 1/3 of the screen and Workbook 2 2/3 of the screen, but if I can only do 50:50 I'm happy to just accept that. I want Book 1 to close as it is merely a tool to open the other 2 spreadsheets.
The problem I am having is that when it arranges the spreadsheets it's including Book 1 in the vertical split as that instruction is there before the instruction to close.
I am also using a dual screen set up, I want the workbooks to open on the 2nd screen, the line 'Application.Left = 1150' opens the workbooks at the furthest point left of the second screen.
Any help would be most appreciated. I've probably gone about this completely the wrong way but I'm still trying to learn VBA etc.
Thanks in advance