Hello,
I have a workbook template with a custom tool bar with command buttons that
have assignments to local macros within the workbook. These files are kept on
a network share.

The issue is when one user has the file up on there PC and another user
tries to open that workbook they receive the "File in use" message box which
give them the options to (Open as read only, notify or cancel) This issue
doesn't occur when you select open as read only or notify, however if you
click cancel and shut down Excel. Next select a another existing file that
was built off of the same template one of the buttons on the custom tool bar
is maintaining a reference to the macro in the workbook that you got the
"file in use" message box. When you click on the link you get the message box
disable or enable macros if close down this message box without clicking one
of the macro options you receive a Excel popup box that says "400" with no
other text. To correct this issue you would have to shut down the workbook
and then go back into it to get it to point to the local macro.

Thanks for your help!

--
Daryl