Let me just start by saying everyone's definition of a good macro shot is different. If were talking closeup photography vs a true macro then I would say it's going to be tough with that particular camera.
The SD600 is a point and shoot which doesn't afford you the same level of control that an Advanced Point and shoot or more so a Dig SLR provides. There are a few limiting factors some of which are the lack of control over focus and manual adjustments like aperture and shutter. Physical size also plays into the mix, the small size is great but it comes at a price, one of which is a limitation on optics. It's not impossible to get good close up shots but true macro with sharp details is another story.
I have owned a few canons, and at the moment have older canon model s40 which is advanced point and shoot, and also old school D60 Digital SLR
When I use the S40 P&S the best shots have been able to get have been with a tripod and placing the camera on a timer so that when I press the the shutter camera shake and long exposure needed to get a decent picture becomes less of a factor.
Just the tip of the iceberg there are so many others things involved, and it could get boring real quick. Hopefully you even made it to the end this.
I hope this offers some insight, I can see by avatar that your not a beginner, nice shot! Just though I would chime in. Have a good one, Mike