Hello all,

My code below creates a floating menu called "New Name", but when I
click on the menu, nothing happens. I want it to display a message.

I have written as...

have you assigned a macro to the button on the floating menu? (assuming
it is a custom button and not a built in button)

--
Regards,
Tom Ogilvy

"shashi1515" wrote
in message ...

Hello all,

My code below creates a floating menu called "New Name", but when I
click on the menu, nothing happens. I want it to display a message.

I have written as...

Tom,

The button I created is on a Floating Menu bar. I know how to assign
macro to button created from Forms. but, how should I assign a Macro t
a button on floating toolbar. Please help.

Thanks,
Shash

--
shashi151
-----------------------------------------------------------------------
shashi1515's Profile: http://www.excelforum.com/member.php...fo&userid=3110
View this thread: http://www.excelforum.com/showthread.php?threadid=50823

In code, you use the OnAction property.

manually, you go to Tools, Customize,
then go to the control and right click on it and select assign macro.

--
Regards,
Tom Ogilvy


"shashi1515" wrote
in message ...

Tom,

The button I created is on a Floating Menu bar. I know how to assign a
macro to button created from Forms. but, how should I assign a Macro to
a button on floating toolbar. Please help.

Thanks,
Shashi


--
shashi1515
------------------------------------------------------------------------
shashi1515's Profile:
http://www.excelforum.com/member.php...o&userid=31109
View this thread: http://www.excelforum.com/showthread...hreadid=508233

Thank you. I got it.

But, when I close the excel and re-open it, I have to assign the macros
again. How to make them permanent??? Please advice.

Thanks,
Shashi


--
shashi1515
------------------------------------------------------------------------
shashi1515's Profile: http://www.excelforum.com/member.php...o&userid=31109
View this thread: http://www.excelforum.com/showthread...hreadid=508233

I haven't seen such a problem unless you have deleted the menu item in which
case, when you create it again, you would need to assign a macro.

--
Regards,
Tom Ogilvy

"shashi1515" wrote
in message ...

Thank you. I got it.

But, when I close the excel and re-open it, I have to assign the macros
again. How to make them permanent??? Please advice.

Thanks,
Shashi


--
shashi1515
------------------------------------------------------------------------
shashi1515's Profile:
http://www.excelforum.com/member.php...o&userid=31109
View this thread: http://www.excelforum.com/showthread...hreadid=508233