Thanks for the reply Alphafrog. So while I was able to incorporate your suggestions into my excel macro and get that working, the VBS recommendation you have wont call the macro when the PERSONAL.xlsb is opened or closed. Using my VBS I can call the xls macro (with your inclusions) and it will run fine so long as the xlsb file is closed. It seems the trouble may be pointed to mine and your VBS. Neither of them call the xls macro when xlsb is opened. Any other suggestions?

For reference, this is your suggestion that is not working at all.
Sub ExcelMacroExample()

Application.Run "'C:\FILEPATH\PERSONAL.XLSB'!Macro1"

End Sub