Open two workbooks into one excel program, then macro code for button to switch between

Hi all
I have two workbooks in a folder that have links between them. (becasue there are just too many sheets for one workbook) I have found that these links only work if both workbooks are open at the one time within the one episode of excel. Currently I am the only person that uses the workbooks so open both and use the view menu tab, switch window button to switch between workbooks.

This works fine for me but now we are getting some new staff who will all need to use these workbooks and enter data. I know that there will be problems with the links. Even with training I know that there will be issues and I am not always going to be there to sort it out. The other problem is the data will get corrupted and be inacurate.

What I am hoping to be able to do is to make it that when one of the workbooks is opened that the other one will open in the background regardless of which workbook is opened, thus maintaining the links. The other thing that I was hoping to be able to do is get some assistance with the code for a macro to save in both workbooks to activate with a button at the top of the sheets in both workbook to act like the switch between workbooks button in the view tab, so that you can switch between workbooks with the click of the button at the top of the worksheet that you are working in.

I am not sure it the is possible but it would be great if someone is able to advise me.

thanks in advance.

Thanks FDibbins, I have just used the ALT TAB as suggested and recorded it as a macro and it works great. I don't tend to use short cut keys much maybe I need to pay more attention to them.
Do you know about being able to open both workbooks at once?
Thanks again, Oldboots

Hi Winon, thanks for your suggestion it sounds good but I am not familiar with the workbook open event. If you are able to help me with the code that would be a fantastic help. The two workbook file names are “IM Client Data new template.xlsm” & “Client list for all FMP Workers.xlsm”.
I look forward to your reply,
Thanks, oldboots

Hi JosephP, I do take on board what you mean, unfortunately I will have to keep working with the dinosaur that I have inherited. When I get all the bugs ironed out I will probably get time and have the information I need to develop a new workbook.
Thanks for your input.
oldboots

Hi Winon, thanks for taking the time to assist me with this little problem I have. I have copied and pasted the code as you suggested but I just can't seem to get it to work. I have attached the two workbooks with the code in them. Would you be able to assist me again by having a look and see if I have the formatting of the path correct and if not as I believe can you suggest the correct way.
Sorry to be a pest I know this is simple but I just seem to get it working for me.
regards, Oldboots