Hi, I know this thread is marked as 'solved' - but I can't help adding a variation to the solution found. (This was lightly touched on by parry above)

Instead of having a macro (with code in it) and a button with separate code that is simply used to call the code in the macro - just go into the macro, copy or cut the body of the code and paste THIS as the code for the button...Is more direct and less error-prone that way.