Good Morning D_Rennie . . .

I can make this work by putting both macros into the module of the workbook first opened from the short-cut. Problem being that it won't run automatically. If I go to the module and run it, it works fine.

I don't understand what you mean by putting the macro named Private Sub Workbook_Open() into ThisWorkbook. Can you tell me where I should put it instead of the module?