Shared Workbook Changes not saving

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!

Hmmmm....
try:

ThisWorkbook.AcceptAllChanges
ThisWorkbook.Refresh

Thisworkbook will refer to the workbook containing the code, ActiveWorkbook means the code will run on any workbook that is currently active.

There is no Refresh in Excel VBA, RefreshAll refers to queries. Maybe it should have been

ThisWorkBook.Save

However, sharing a workbook is not a good idea