Macros working only when workbook is not shared

[OfficeUser]

I have a user who recently had to have MS Office reinstalled. Since then, he cannot run macros in the workbook which he used daily up until the reinstall. If I unshare the workbook, then he can run everything as before. I have checked add-ins and macro settings, but am stumped otherwise. An ideas on where I should look to figure out what is different? Thanks for your help!!

 

[igold]

Shared workbooks have certain limitations using macros... If you Google something like "excel vba shared workbook limitations", you can find a slew of information on this subject...

 

[OfficeUser]

I have been reading a lot about this recently. The oddity is that this worked perfectly fine on the the same computer before the reinstall of Excel, same version, which makes no sense to me. I keep thinking it has to be an add-in but everything is installed as before.

 

[Peter_SSs]

I presume that you have checked things like whether macros are enabled or whether the file location or the file itself is "trusted".

Did the computer also get a different version of Windows installed?

Are the macros in the shared workbook itself or in an Add-In or elsewhere?

What was the old Office version? .. and the new one?

 

[OfficeUser]

I did check to ensure macros are enabled, and the file is trusted, we removed it from the trusted status and trusted it upon reopening. Windows remains the same, and was not reinstalled. Macros are in the shared workbook. This shared workbook is used across seven computers all which are able to run it without cause for concern, with the exception being this one recently. Office version is 2010, old and new. I wonder if its an Office Update that needs to be reinstalled...? All good questions / thoughts. thank you.