Shared Workbook

[adamsm]

Hi anyone,

How could I make a macro enabled workbook to be shared on a network location where other users can gain access to it and edit information at the same time.

I've tried the instructions in the following link but it says it would not allow macro enabled workbooks to be saved on shared locations.

http://support.microsoft.com/kb/269860

Any help on this would be kindly appreciated.

Thanks in advance.

 

[Hermanito]

That link points me to the Dutch version of a knowledge base article which doesn't say anything about macro's... it's about shared workbooks being used in different Excel versions at the same time...

As far as I know, a shared workbook can contain macro's, but those macro's suffer the same restrictions as normal users in a shared workbook: certain functionality is not available... if the macro tries to use it anyway, you will get a runtime error (unless errorhandling is implemented properly).