If you want to have it happen automatically after an agent in a queue hangs up, set the "Queue Continue Destination" to be "Custom Destination" then "after call survey" in the drop box
If you want do it using a transfer, I'd create a ring group. in the extension list put a dummy extensions that doesn't exist, for example "1". Then set the failover destination to be the custom destination "after call survey".
Your employees can transfer to the ring group and it will failthrough to the survey.
...or are you doing this method and the macro is not running?