template button network wide

Giganews Newsgroups
Subject: template button network wide
Posted by:  kurt (kmetzg…@isd.net)
Date: Thu, 2 Oct 2003

I have created a timesheet which needs to be loaded on a
server for access by all users.  I want to have a button
on a NEW toolbar which is linked to a macro that
generates a new timesheet based on the template.  This
New toolbar must be loaded on each user's pc when they
open Excel.  I want to have access to the toolbar for
modification from the SERVER side.  Then as each user
logs in, they'll see any changes to the toolbar/macros
that I've made.  I can do this in Word by creating a
template with a new toolbar.  The template is then saved
on a network directory.  Then, Word's startup folder
location is modified to point to the directory where I
load the new template, and each user can click the new
buttons/macros I've created since they will appear in
Word automtically as the template is loaded when Word is
launched.

I have not been able to accomplish the same thing in
Excel.  I believe it has something to do with where the
macros are stored in Excel.

ANY HELP WILL BE GREATLY APPRECIATED on how to do this in
MS Excel 2002.

THANKS!

-Kurt

Replies