With the help from AlphaFrog, I have some VBA code in a XL 2010 Workbook. The original workbook was a 2010 xlsx file, but I saved it as a xlsm file. Then put my code into the sheet1 VBE. Worked perfect with a couple small adjustments for ranges etc.

I placed buttons on the "Customize quick access toolbar". The code ran smoothly until I shared the workbook.

I have enabled "Run all Macros", added the document to the trusted locations in the trust center.

Can anyone suggest why this may be happening?

Thank You