Did you place that button on a worksheet?

If yes, then it sounds like you used the commandbutton from the Control toolbox
toolbar.

You can delete that commandbutton and replace it with a button from the Forms
toolbar. Then you'll have that option to assign the macro.

Mandy wrote:

Please can anyone help.....

I have created a macro, but don't have the option of assigning it to a
button, I've created a toolbar and added the button but when I right click
on the button I don't have the assign macro option. I'm using Office 2003

--

Dave Peterson