saving shared workbooks using macro

[uniks]

hi everyone,
is it possible to save a shared excel file using a macro?
i've tried this code but it didn't work

Please Login or Register  to view this content.

Thanks

[:) Sixthsense :)]

Where your code will reside?

The code kept in the shared workbook itself?

or

In some other workbook?

Please confirm