A man accused of attempted murder in connection with the alleged firing of a crossbow has been deemed unfit to stand trial.