I don't think you can hide a button using a macro unless its with the "Set Value" function?. But there are two ways I know of. The lazy way is if the last action on your macro for example fills in data into a text box on the form then use that text box "After update" event to hide the button.
Or the better way,
Convert your macro into VB and add the code at the end in this format
YourButtonName.Visible = False
Remember you will also have to reverse that action at some stage to enable the button again.
If you don't know anything about VB then now is a good time to start.