call a sub from an xls file on the network

[XDKYX]

I'm trying to call a sub in an exce. file that resides on our network drive so that multiple users can access the programs that I develop and I can get VBA to open the file but I can't get it to open the sub titled "DCU". I keep getting the following error.

Cannot run the macro DCU. The macro may not be available in this workbook or all macros may be disabled.

Here is my code that errors.

Option Explicit
Sub DESCRIPTION_CLEANER_UPPER()
Application.Visible = True
Workbooks.Open Filename:= _
        "\\Cansvp01\grp_01f\Common\Common-Parts\Prcng\Macros\Macros.xls"
Application.Run "DCU"
End Sub

Any help is greatly appreciated, maybe I'm calling it wrong or maybe there's another way to accomplish what I'm trying to do here.

 

[XDKYX]

The read-only file in the XLSTART folder works like a charm, thank you so much!

######### SOLVED #########

 

[XDKYX]

The final solution (for me) was to put the file Macro.xls on a network drive and then make it read-only in the file's properties. From there I put a shortcut in the 'XLSTART' folder so that it started up everytime I started Excel. At that point when I go to run a macro my DESCRIPTION_CLEANER_UPPER macro is available and I don't need another macro to point to it.
Thanks for all of your help guys, I don't know where I would be without that support.
Other forums I posted in:
http://www.xtremevbtalk.com/showthread.php?p=1306578
http://www.mrexcel.com/forum/showthread.php?p=1701261
http://www.excelforum.com/excel-programming/657235-call-a-sub-from-an-xls-file-on-the-network.html

 

[schielrn]

Thats great to hear that it worked. Did you do anything with the visible window?

 

[XDKYX]

Yes, (since I'm using 2007) I went to the View tab on the ribbon and clicked on the 'hide' button (in the Window section) while I had the Macro.xls open and now it's hidden for me and anyone else who opens it.