Forum Discussion
netostark
Feb 28, 2023Copper Contributor
Problem with Macros on network file
We have the problem that on a xlsm file that is shared on our local network for one of the users one of the macros stopped working properly but showing no error message, it just does nothing. The ma...
Patrick2788
Feb 28, 2023Silver Contributor
I'm going to guess: the XLSM was opened from the network, macros were enabled, and at some point 'yes' was selected when prompted to make the document trusted.
Go to File | Options | Trust Center | Trust Center Settings | Trusted Documents - clear the trusted document cache.