View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default Macro Fault on Custom Ribbon

Make sure the macro is "available". Spelled right, in the same workbook,
etc. If you're sure that you did everything right feel free to send me the
workbook. I've done a thousand ribbons; or it feels that way<g.

--
Jim
"Karen" wrote in message
...
| Hi,
|
| I'm trying to create my first custom ribbon, using example code. I saved
a
| workbook as testingtoolbar.xlsm as well as testingtoolbar.xlam.
|
| The ribbons are visible as well as the solitary test button but when the
| button is activated I get the following error message:
|
| "Cannot run the macro 'myButton_ClickHandler'. The macro may not be
| available in this workbook or all macros may be disabled."
|
| The folder is a trusted location, it is the local user XLStart folder.
| I have enabled all macros
|
| Any suggestions as to how to enable macros for a custom ribbon are welcome
| :)
|
| Karen
|