This is a discussion on Excel 2010 Macro in Shared Workbook within the Excel Questions forums, part of the Question Forums category; Hello With the help from AlphaFrog, I have some VBA code in a XL 2010 Workbook. The original workbook was ...
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?