Forum Discussion

Abruce9519's avatar
Abruce9519
Copper Contributor
May 03, 2024

Excel Macro only allowing a single use.

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.

 

Regards,

Dan

No RepliesBe the first to reply

Resources