Put the camera on something solid or tripod, set it up to use the timer, focus and set up shot (usually push button down half way), click and walk away.
Some macro settings in P&S cameras need you to be ridiculously close to the subject before it will focus. Make sure to have brilliant lighting.
Sometimes, point and shoot cameras just don't take good macros.![]()