It will work if you create a button  using the form toolbar, copy the code into a
module (without Private before Sub) and then assign the macro to the button. I
have no idea why it works this way but not with the ControlBox button! I have
attempted both - one works, one doesn't.

Perhaps someone else will be able to help with the logic of it!