View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default How to run a macro in code


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 ?