I am in the middle of trying to convert my file from a permanent reference to
using RUN. In the main spreadsheet are a number of userform buttons which
call a macro (Sub Menu_New_Site) in one of the modules in the .xla. When I
have a reference set to the .xla the buttons work fine, if I remove the
reference I get the following error:

"The macro 'Menu_New_Site' cannot be found"

Any ideas?

--
Trefor

I think I'd create a local macro that calls the macro in the .xla. (It seems
easier to me.)

sub Local_menu_new_site()
application.run "'addinname.xla'!Menu_New_Site"
end sub

I didn't test this, but it seems like it would react to changes in the xla
location better than assigning the macro directly.

Trefor wrote:

I am in the middle of trying to convert my file from a permanent reference to
using RUN. In the main spreadsheet are a number of userform buttons which
call a macro (Sub Menu_New_Site) in one of the modules in the .xla. When I
have a reference set to the .xla the buttons work fine, if I remove the
reference I get the following error:

"The macro 'Menu_New_Site' cannot be found"

Any ideas?

--
Trefor

--

Dave Peterson

Dave,

Many thanks, this is my backup if I can not get an answer to my thread "VBA
code to set a reference". If I can get this to work I will not have to make
the changes as you have suggested (I have about 50 button's, so I am not
overly keen to going and edited them all, but will if I have to!)

BTW is there any difference between:

application.run "'addinname.xla'!Menu_New_Site"

and

run "'addinname.xla'!Menu_New_Site"

I have been using the later, is this an issue?

--
Trefor


"Dave Peterson" wrote:

I think I'd create a local macro that calls the macro in the .xla. (It seems
easier to me.)

sub Local_menu_new_site()
application.run "'addinname.xla'!Menu_New_Site"
end sub

I didn't test this, but it seems like it would react to changes in the xla
location better than assigning the macro directly.

Trefor wrote:

I am in the middle of trying to convert my file from a permanent reference to
using RUN. In the main spreadsheet are a number of userform button€„¢s which
call a macro (Sub Menu_New_Site) in one of the modules in the .xla. When I
have a reference set to the .xla the button€„¢s work fine, if I remove the
reference I get the following error:

"The macro 'Menu_New_Site' cannot be found"

Any ideas?

--
Trefor

--

Dave Peterson