Dave,

Thanks for your reply, but I don't think this approach will work fo
me.
My application is as follows:
Using some financial software that we subscribe to, a report o
selected securities is created. One of the report options is to outpu
to an Excel workbook; thus, a new workbook is opened each time th
report is run. My objective is for each network user to have access t
shared macros that would operate on this workbook. Access would be vi
clicking-on Custom Menu Buttons on the Standard Toolbar; these button
would be linked to various shared macros.

This objective can be achieved by e-mailing each user a workbook (wit
a name anything other than Personal.xls) that would be stored in eac
user's XLSTART folder. The e-mailed workbook would include a macro t
store the file in the appropriate folder (would have to be customize
for each user on the network).
Each user's Standard Toolbar contains buttons linked to specific macro
in the common workbook (identical except for the customized sav
macro).

Gord indicated that saving the workbook as an .xla file on a share
network drive as an alternative. I am still pursuing that solution.

Thanks again,
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26591