Hi everyone
I've got a
Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
macro in a workbook. When I Manually save the file it works no worries.
However..
When I open the file with a macro in another workbook and then save it with the ActiveWorkbook.Save command the before save macro doesn't fire.
Any ideas?
Surely it doesn't only work when you save it manually. (Stop calling me surely!)
thanks in advance