One workbook affects all workbooks

The code should go into the ThisWorkbook module

Thanks It works was placing in the wrong module

I ran two other macros and this time close more menues but it did not run see attached.

The sheet has copies of my macros look at the one with lots of delets.