Try this:

1. Insert a module in the workbook where your button is; (VBE, insert,
module)
2. Copy the code from your Personal.xls to this module;
3. Go in the sheet where you have the button (right-click reassign
macro, and point to the one in your workbook)
4. ... Good Luck

Philippe Léveillé

"William Benson" a écrit dans le message de news:
...
I have a command button on Sheet1
the click event says
application.run "personal.xls!OtherMacro"

The called macro is in a code module named "MyModule" in personal.xls. It
is declared as
Sub OtherMacro()

I am getting an application error every time the click event fires, any
ideas? TIA ... Bill