Don,
I'm not familiar with your camera, so i can't speak with any authority from that perspective. I do know when my camera is in "Macro" mode to have things in focus the lens needs to be very close to the object.
As it’s a digital try this little experiment. Set your camera up as if you were photographing a pen. Lay down a ruler, lengthwise, i.e. the start (0 mark) is closest to the camera, the 12†mark farthest away. Place the camera nice and close, (maybe 3†away from the ruler center) you’ll probably only see the 4†and maybe the 12†marks on the ruler. With the camera in Macro mode, shoot your picture. Don’t move the camera, take it out of Macro mode, shoot again.
Now move the camera back to say 18†away, shot again on both modes, zoom in so you can see detail marks on the ruler.
View the enlarged images on your computer monitor should tell you bunches of information. i.e. what setup gave you the best focus, you will see how important depth of field is and how it relates to where the camera is placed relative to the object being photographed....
Do some more experimenting, it’s digital, shoot away!!!
Happy turnin'