I have an excel macro enabled workbook that has 4 macro buttons in it for saving and emailing various groups of people. We have been using it for quite a while and have had no issues. Initially it was set to save to the users local directory. As a company we are moving to onedrive so I have been changing the macro's to save to the users onedrive. I have it working with one issue: One I save it to onedrive, I then want to run the macro to convert it and email the PDF after I have finished it. The file in Onedrive opens using my desktop excel(latest version of O365), I click a macro button, it works but then the file does NOT allow me to click any of the other macro buttons. I have to close the file down and reopen it to reactivate the other macro's. And again, it only lets me click on 1 button then inactivates the others. I have checked and all my macros are enabled, my onedrive is a trusted site etc. I am not sure if this is a onedrive issue or how to fix this.
Thank you
Tanya
Thank you
Tanya
