Sharing Excel Workbook with more than one user

[RESPUZY]

Hello Experts,

i have an excel templates where i want users to be able to access it almost at the same time if the so wish so i activated the share workbook option on the review menu, however, its giving an error because the template contains macro and it says macros cannot be shared, pls is there a way around this where different users can access my file at the same time. thanks

 

[Almir]

That means that macros can not be viewed or changed. However, macros will run normally in a shared workbook.

 

[RESPUZY]

That means that macros can not be viewed or changed. However, macros will run normally in a shared workbook.

But the macros dont work when i share the workbook and that is what i seek help around. thanks

 

[Almir]

They are supposed to work. Did you check macro security level? Maybe macros are disabled.