SendKeys won't fire on Workbook_Deactivate or Workbook_BeforeClose

Try inserting:

DoEvents

immediately after the SendKeys

Thanks Jakobshavn...that works fine when closing the workbook! However, when switching between workbooks, the other actions work fine, but the ribbon won't restore. You did so good with your first suggestion, how about taking a shot at this one

NEW INFO: Interesting...if I switch between this workbook and another xlsx file, it works fine. But, if I open a new workbook while this one is open, it doesn't toggle the ribbon when switching between those two books.