exactly the OP's point
other_macro will give compile error
if created_macro does not exist.
use
application.run thisworkbook.name & "!created_macro"
make sure created_macro is not private.
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Snake Plissken wrote :
sub created_makro()
'bla bla
end sub
sub other_macro()
call created_makro
end sub
is that what u looking for?
After I created a macro, how do I run this macro in code ?