Excel Macro only allowing a single use.

Copper Contributor

Hi all


I have been using macros on my invoicing sheet for a short while now, however today I have processed an invoice and used a macro to 'SaveAs'. The problem I am having is that each time I open excel and go through the process of generating a new invoice, excel runs fine. As soon as I go to run the macro again it gives a run time error and says I don't have the sharing permissions for a folder.


I am struggling to understand how It can run fine, then not. If I quit excel and run the macro again it works fine. This surely has to be a simple fix, yet I cannot seem to find the problem. 


I have recently upgraded my OS on Mac to Sonoma 14.14.1 - perhaps this has something to do with it.


Any help is much appreciated.




0 Replies