Hi great that it works well now. To make sound hearable only for some distance you need to use Attenuation Settings. In Play Sound at Location node you can press that white arrow to get more settings and there will be Attenuation. By default it’s empty.
Just create new Attenuation (it’s in Sounds category) and adjust ranges. And then select it in Play Sound at Location node.
More details in the doc: Sound Attenuation in Unreal Engine | Unreal Engine 5.0 Documentation