If society collapses and money is now useless, what will people use as currency?

Depends on just how collapsed shit is.

Given what a small percentage of the overall money supply actual cash is, I wouldn’t be surprised if it re-emerged as a currency, although completely divorced from the former economic system that spawned it.

If it’s a major, hardcore collapse, it will probably be straight barter, with even precious metals being of limited value.

Nobody is gonna trade you something as precious as food or ammunition for your shiny rock.