attach macros to custom menus

[Guest]

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 exist
*Make sure the folder that contains the file is not read-onl
*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

 

[Jim Cone]

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

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

*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?

 

[Jim Cone]

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

The toobars have been attached to the workbook... how can I get then the

macros attached to just the workbook as well?