Because the macro is in an add-in the macro won't show up in ToolsMacroMacros

Just right-click on the object and "assign macro"

Type the macro name......Move.........into the dialog box.


Gord Dibben MS Excel MVP

On Wed, 16 Jul 2008 07:24:00 -0700, Varne
wrote:

Hello!

Could somebody help on this place?

I created an Excel Add-In file.

Then I inserted a module.

I wrote the following codes in it;

Sub Move ()

activecell.offset(0,4).select

End Sub

Now I like to run this macro on a normal xls. work book by clicking an
object. Circle, button or rectangle. I am not able to assign a macro to an
object because nothing appears when I open the Macro box that contains Macros.

Thanks.

Regards
M Varnendra