Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"

Hello,

I have a macro that essentially does the following:

• Opens a file
  Adds a button to the opened workbook
  changes the "OnAction" property to a macro that is within the open workbook

however, I am not able to do the last step...

here is the code I am using:

Please Login or Register  to view this content.

where Report is a Workbook variable that was set to the opened file.

The error I get is:
"Cannot run the macro '[wbname]!Module1.OpenHyperlink'. The macro may not be available in this workbook or all macros may be disabled"

Is there a reason for this or something I can do to fix it?
NOTE: the workbook is correct and the shape is correct (I have checked)

Ok so I changed it to the following:

Please Login or Register  to view this content.

But I get the same error.
All the elements for the macro, exist on the workbook that I have defined "Report". The shape, the macro, the code all exists within the same location. But for some reason I cannot link them together.

Just a quick note on the fix,

the fix is essentially that the name must be:

Please Login or Register  to view this content.

I missed out the ' marks.
Problem solved now