S
stonet
I have a Workbook (Workbook1) that references another Workbook
(Workbook2) that contains a number of routines. Workbook2 contains the
routines and the reference is made in the Workbook_Open Event of
Workbook1.
There are a number of buttons on Workbook1 that run code in Workbook2
when clicked.
They are not Command Buttons as the original code was written for
Office95.
Having now moved to Office 2003 (after moving through the various other
Office releases) the end users are experiencing problems. When they
click the buttons they receive a message saying that the macros can't
be found.
If I right click on the button and re-assign the macro it works fine
but if the end user tries to run the macros they intermitently receive
the error even if I have saved the Workbook. The error says that it
can't find the macro and gives one of two fielpaths, either just the
mapped drive or the mapped drive including the Network server name i.e.
either T:\... or the same message but with the server name in front.
If when you right click on the button, the button is just assigned to
the name of the macro i.e. Workbook2'!Macro1 then it works fine but for
some reson when somebody else opens the Workbook, this is not what they
are seeing.
I can't just delete the buttons and replace them with Command Buttons
as there are 250 versions of Workbook1 and there are also 3
Dialogsheets that have buttons on them.
Has anybody and ideas as to why this is happening and if it is an
Office 2003 problem or a Network server problem
(Workbook2) that contains a number of routines. Workbook2 contains the
routines and the reference is made in the Workbook_Open Event of
Workbook1.
There are a number of buttons on Workbook1 that run code in Workbook2
when clicked.
They are not Command Buttons as the original code was written for
Office95.
Having now moved to Office 2003 (after moving through the various other
Office releases) the end users are experiencing problems. When they
click the buttons they receive a message saying that the macros can't
be found.
If I right click on the button and re-assign the macro it works fine
but if the end user tries to run the macros they intermitently receive
the error even if I have saved the Workbook. The error says that it
can't find the macro and gives one of two fielpaths, either just the
mapped drive or the mapped drive including the Network server name i.e.
either T:\... or the same message but with the server name in front.
If when you right click on the button, the button is just assigned to
the name of the macro i.e. Workbook2'!Macro1 then it works fine but for
some reson when somebody else opens the Workbook, this is not what they
are seeing.
I can't just delete the buttons and replace them with Command Buttons
as there are 250 versions of Workbook1 and there are also 3
Dialogsheets that have buttons on them.
Has anybody and ideas as to why this is happening and if it is an
Office 2003 problem or a Network server problem