Running VBA macros in a shared document

[Shaulm]

I have an excel workbook which has several VBA forms with macros running to handle the information inserted by the user.
Everything runs well until I define the workbook as shared, allowing others to make changes to it. Once defined, one of the forms aborts with the following error:

'Run time error '1004':
Application-defined or object-defined error

I cannot debug the cause for the error on the specific form, as the project is not viewable in the shared mode.

Is there a reason why sharing a document causes this problem?
Thanks.

 

[ttray33y]

I have an excel workbook which has several VBA forms with macros running to handle the information inserted by the user.
Everything runs well until I define the workbook as shared, allowing others to make changes to it. Once defined, one of the forms aborts with the following error:

'Run time error '1004':
Application-defined or object-defined error

I cannot debug the cause for the error on the specific form, as the project is not viewable in the shared mode.

Is there a reason why sharing a document causes this problem?
Thanks.

macros on shared workbook has limitation. and one of those is what you are experiencing now.

 

[Shaulm]

macros on shared workbook has limitation. and one of those is what you are experiencing now.

Thanks for the reply.
Is there a common workaround to use forms in a shared workbook?

 

[ttray33y]

Thanks for the reply.
Is there a common workaround to use forms in a shared workbook?

it will insufficient IMHO, if it just a data entry sheet then for multi user MS Access is your friend.

 

[Shaulm]

OK, thanks. I'll look into it.