shared work book

[darknight]

i know how to share a workbook in excel. But is it possible to share a workbook with macro's?

Cheers all

[mudraker]

Yes it is possible. You can not access the VBA area of the workbook whilst it is shared

You need to build your macros with the workbook not in the shared mode.

When your coding is complete you can share the workbook.

If you need to modify or add more code you will need to remove the share option if you need to remove the share option