If the police break down your door with a warrant - they already have the right to search the place. They don't necessarily have the right to question you without an attorney.
I suspect that while they're searching, depending on the possible charges and what they're looking for, they're going to want you in a place that you offer no danger to them. So that's either outside with other cops watching you, or sitting on a couch or something where you can be watched. In either of those cases, you could probably use your cell phone to call your attorney - but that won't stop them from carrying out the warrant.
If they arrest you as part of the search, then you'll be in handcuffs. I assume eventually they'll let you call a lawyer - but they won't be questioning you outside of the lawyers presence in the meantime.
So - shorter answer - if the police break in with a warrant, you saying you want an attorney won't stop them from carrying out the warrant and searching. But it better stop them from questioning you.