Add-Ins

[Varne]

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

 

[Bernard Liengme]

Did you use Tools | Addins to load you new xla file?
best wishes

 

[TomPl]

For this to work the Macro must be in an open workbook or in your
Personal.xls workbook. Then you should be able to right click on the object,
select assign macro and it should be listed.

tom

 

[Gord Dibben]

Because the macro is in an add-in the macro won't show up in Tools>Macro>Macros

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

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


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Won't be listed when the macro is in an add-in.


Gord Dibben MS Excel MVP

 

[Varne]

Hi

Sorry for replying late.

Its running I assigned my macro by typing.

Thanks.

M Varnendra

 

[Gord Dibben]

Good to hear

Gord

Hi

Sorry for replying late.

Its running I assigned my macro by typing.

Thanks.

M Varnendra