Create the button using the Forms Toolbar and not the Control ToolBox

Then you will get the Assign Macro option.


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 19:59:21 -0800, melaniem
wrote:

I created a macro that will hide a chunk of data so that I can copy and paste
select information to send to someone.
I added a radio button or command button.

If I create a check box, I can right click and say "assign macro". When I
try to assign a command button I do not have the same option.

I tried going into the view code but I haven't got a clue what to do when
I'm there.