Shared Workbook Changes not saving

[techteam]

Hi All

I have a shaared workbook which contains macros.

All the macros work fine, but, for some reason, when i use the code:

ActiveWorkbook.Save

The changes that other people make aren't showing.

Normally, in a shared work book, if i make a change, then save using the traditional ctrl+s or... just going to the menu and clicking save, my changes will show on the other persons workbook if they then save too.

But with the above code, that doesn't happen.

Is there a special code that saves the workbook and allows the changes to be seen?

Many thanks!