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

Did you use Tools | Addins to load you new xla file?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Varne" wrote in message
...
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

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

"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

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

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


Gord Dibben MS Excel MVP

On Wed, 16 Jul 2008 07:54:02 -0700, TomPl
wrote:

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

"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

Hi

Sorry for replying late.

Its running I assigned my macro by typing.

Thanks.

M Varnendra

"Gord Dibben" wrote:

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

Good to hear

Gord

On Fri, 18 Jul 2008 07:00:00 -0700, Varne
wrote:

Hi

Sorry for replying late.

Its running I assigned my macro by typing.

Thanks.

M Varnendra

"Gord Dibben" wrote:

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