I'm trying to create templates in Excel 2003 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?