Hello
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
Terry
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
Terry