Problem with assigining a macro.
 

Hello,

I have created a floating menu bar with 3 menu buttons on it. I have
written a sub programs for each button, for the action to be performed
when the menu buttons are clicked. And I have assigned the code to the
buttons using "Assign macro". This works fine unitll the workbook is
closed. When I close & re-open the workbook and click on menu
buttons....I get a message that it could not find assigned macros. I
saved the workbook before closing. I tried many times, but could not
find the reason. 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=509361

Problem with assigining a macro.
 

run a macro to check on the assignment

Sub showAssignments()
for each btn in CommandBars("MyBar").Controls
msgbox btn.Caption & vbNewline & btn.OnAction
Next
End Sub

Try it before closing the workbook, when the workbook is closed and when
you have a problem.


I create custom bars all the time when I am testing things. I will make
them visible weeks or months later, and click a button and it opens some old
file it was assigned to and runs the macro. So this isn't typical.

--
Regards,
Tom Ogilvy


"shashi1515" wrote
in message ...

Hello,

I have created a floating menu bar with 3 menu buttons on it. I have
written a sub programs for each button, for the action to be performed
when the menu buttons are clicked. And I have assigned the code to the
buttons using "Assign macro". This works fine unitll the workbook is
closed. When I close & re-open the workbook and click on menu
buttons....I get a message that it could not find assigned macros. I
saved the workbook before closing. I tried many times, but could not
find the reason. 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=509361

Problem with assigining a macro.
 

You need to attach the floating menu bar to the workbook - use the attach
command in the worksheet menu bar to do this.

--
www.alignment-systems.com


"shashi1515" wrote:


Hello,

I have created a floating menu bar with 3 menu buttons on it. I have
written a sub programs for each button, for the action to be performed
when the menu buttons are clicked. And I have assigned the code to the
buttons using "Assign macro". This works fine unitll the workbook is
closed. When I close & re-open the workbook and click on menu
buttons....I get a message that it could not find assigned macros. I
saved the workbook before closing. I tried many times, but could not
find the reason. 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=509361