The answer is no.
Focus and depth of field are independent and turning off macro focus won't affect the depth of field.
Here is a scenario that I have turned off macro focus.
I was shooting a baseball game from behind home plate through a net. I had the camera as close to the net as I could, which was about 2 inches from the front of the plastic lenscover deal.
I want to focus on the batter about 15 feet away. At first I had Macro focus on. The auto focus would work, and the netting acroos my lens was so close, it would virtually disappear. However, if I followed the player to first base, the autofocus would focus on the net.
With Macrofocus turned off, it would disregard the netting, and I could stay focused on the player or the outfield.
John
John Lenihan
LeniCam Video Productions
http://www.lenicamvideoproductions.com