Hi,
If you are trying to assign a macro to a button, use the bring up the
forms toolbar click on button and place it in your spread sheet, right
click and assign macro,
it sounds like you tried to use the button from the control toolbar,
Dave