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

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