BeforeSave not working properly

I have a workbook with a BeforeSave macro. It works fine if you run another macro before the first time you try to save and works fine if i press the save button a thousand times (i assume, haven't actually pressed it that many times), but if i press the save button and then run another macro, when i press save again the macro doesn't run.

Does anybody know why???

Thanks

Please Login or Register  to view this content.

I guess because you haven't included a worksheet reference. Without this it will run on whichever sheet happens to be active at the time.

You beauty