Hi Jason,

I agree with Bill's suggestion.
Based on my test, a network shared workbook will be opened by multiple use
as readonly, and the macro will run.
But as Bill said, you need to change your macro security as a lower level,
because for the users who opened them from the network, the workbook is
opened from a non local place.

e.g. you may change the security to low for a test.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.