Sending Personal.xls Files To Multiple Users

[Chuckles123]

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

 

[Dave Peterson]

It sounds like you have the code duplicated in each of the workbooks you open.

If that's the case, it might be time well spent to separate your code from the
data.

It's a real pain to fix code in who knows how many workbooks--instead of just
fixing it in the addin (I like Gord's idea) once and either redistributing it
(or updating the network location).

But take a look at John Walkenbach's menumaker. I still think that it may do
what you want.