I turned it on alright, but when it comes to switching it off, it wasn't as intuitive. Can't figure it out.
You are probably talking about the Close-Up scene mode. It only takes into effect when the mode-dial is at the SCENE position.
To get out of it, either choose another mode or change the scene mode. To change the scene mode, rotate the rear control-dial while the mode-dial is still at the SCENE position.
To further explain the macro vs. closeup issue:
Since minimum focus distance is a function of the lens optics and the lens register (the distance from the outermost edge of the mount to the film plane) and so is the magnification ratio for a given distance, it is understandable how no function on the camera will be able to enable close-up photography without tricks such as increasing the lens register by moving the sensor, adding extension tubes or corrective elements.
Most confusion appears to be due to the misconcept perpetrated by most point and shoot cameras featuring a close-up enabling feature and calling it macro mode: all other factors being equal, a shorter distance implies a bigger ratio, but it is firstmost a feature enabling you to stick the camera at a few centimeters from your subject. On every interchangeable lens camera currently on the market, the camera doesn't automatically implement the above tricks: the "flower" mode is the full auto mode biased to prefer smaller apertures to enhance depth of field, which is gets critically smaller with magnification.