VBA sticking on Save As

[jon1315]

Hi
Something strange has started happening with my code, maybe someone has seen it before?

I have a spreadsheet that is used by multiple users, and one of the parts of the code is to save created sheets (using the wb.saveas ... code)
This has never been a problem, and has been in use since last December (ish).

Recently, the code has started "sticking" on the SaveAs line (i.e it would execute the line, and by going onto file explorer you can see that the code has saved the spreadsheet, but the spreadsheet would stick with the saving window. You then have to manually click "Cancel" on the saving window, and the code will continue).

The fault is intermittent, and several users have reported it. It happened to me this morning and I've no idea how to correct.

Has anyone seen it before?

Thanks
Jon

 

[Yongle]

Please post the full procedure
- someone may spot something or else be able to offer a workaround alternative for you
- click on <vba/> icon and then paste code inside the code tags