R
return2300
I'm trying to create templates that will be copied from a single network
location. I created a toolbar to access the macros for this template and as
the person who created them they work fine for me, but when anyone else tries
to access them the macros don't work from the toolbar. I've gone into the
macro window and they're all present and work when I run them from there, but
the average user will of course not go that route. I've gone in to the
template multiple times to reattach the macros to the toolbar and every time
the macro resets to saying Book.xlt!insertworksheet instead of
insertworksheet. The error that users see say that book.xls cannot be
located. Does anyone know how to get around this problem?
location. I created a toolbar to access the macros for this template and as
the person who created them they work fine for me, but when anyone else tries
to access them the macros don't work from the toolbar. I've gone into the
macro window and they're all present and work when I run them from there, but
the average user will of course not go that route. I've gone in to the
template multiple times to reattach the macros to the toolbar and every time
the macro resets to saying Book.xlt!insertworksheet instead of
insertworksheet. The error that users see say that book.xls cannot be
located. Does anyone know how to get around this problem?