attach macros to custom menus

Jazz,

From your description it sounds like the "workbook" on the shared drive
is looking for the Personal.xls file which is still back on the code writers
computer.

Have you tried it with the macro code added to a regular module in the
"workbook"?
If the macros are in the "workbook" then is the code string, attached to the
menu items,
still referencing the personal.xls file?

Regards,
Jim Cone
San Francisco, CA

"Jazz" wrote in message
...
Complex spreadsheet issue--
I have a client who has put together a workbook in Excel XP with custom menus
and multiple simple macros attached to these menus. He has attached the menus
to the workbook, and saved the macros in his personal macro workbook. This
workbook is designed for mulit-user input in a plant.. the problem is that when
he saves this resource to a shared drive and others attempt to use the menus,
the following error appears...
"The file could not be accessed. Try one of the following:
*Make sure specified file exists
*Make sure the folder that contains the file is not read-only
*Make sure the file name does not contain any of the following
characters?[]: Macro.xls or *
*Make sure the file/path name doesn't contain more that 218 characters"
what is Excel referring to when it says "make sure the file exists"? "file is
not read only"? the excel file obviously exists and it is not read only, there
are not symbols in the filname, the network path and filname are not over 218
characters....
If I open the Macro list, I can see all of the macros in there... macro
security is set to low on all user machines...
What is going on?
Basically, how does one create menus with attached macros and make them
available for multiple users to utilize?

The toobars have been attached to the workbook... how can I get then the macros attached to just the workbook as well?

Jazz,

The macro code should be in the SAME workbook as the custom toolbar.
The personal.xls file should NOT be involved in any way.

I would copy the code from the Personal.xls to a new module in the workbook.
(Alt + F11, Insert | Module)

To be sure, after copying and pasting the code, you could rename all the
macros in the new module by adding a character to the end of each macro name.
"OldMacroName" could become "OldMacroNameW".
Then bring up the "Customize" box by right clicking any toolbar.
Right click each button in the custom toolbar and assign a macro to it.

Regards,
Jim Cone
San Francisco, CA

"Jazz" wrote in message
...
The toobars have been attached to the workbook... how can I get then the
macros attached to just the workbook as well?