View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lance-news@augustmail.com is offline
external usenet poster
 
Posts: 22
Default Running macros from another workbook

I have a workbook called macros.xlm that is a hidden workbook that
I always open when Excel is opened.

If I have another workbook open (say Test.xls) and I create a macro
sub test()

End sub


How do I call a macro from macros.xlm from Test.xls?



I have tried:

sub test()
Run Macros.xlm!A0FormatMeans
End sub

and a few other things but just cannot figure it out.

Lance