i dun think u need to press any button for macro in SLR... if a lens is macro, the focusing can go beyond the standard focusing range, up to 1:1 or perhaps more, norm, 1:1 1:2 1:4 but there is a switch, that prevents the lens from going beyond the standard focusing range.
if u talk about prosumer/consumer camera with the button, it might be same as SLR, its just a switch that lets the focusing go beyond.