Maybe....

If you have a common network folder, you could put your *.xlb file in that
folder (and nothing else).

Then for each user/pc, you'll have to change a setting:
tools|options|General|at startup, open all files in
point at that common folder.

When excel starts, it'll load the user's *.xlb file, but then (very quickly),
that toolbars will be replaced with the one in the common network folder.

====
Another option would be to add something to a workbook (any workbook???) that
opens that *.xlb file:

Option Explicit
Sub auto_open()
Workbooks.Open "C:\yourprivatetoolbarfolder\excel11.xlb"
End Sub

====
Or provide the users with a new shortcut to start excel--but the shortcut
actually copies your *.xlb file into the correct location. This won't help if
the user starts excel by double clicking on a *.xls file in windows explorer,
though.

====

And one more thought.

Don't do this.

If I were one of your users and you destroyed a toolbar file (with no warning!)
that I had customized, I'd be ticked off. I'd look for a different
solution--maybe formatting the ranges each time the user changed selection--or
when it was opened the next time--or....





Paul - NottsUK wrote:

I'm trying to enforce standards on my users so I don't want them customising
fonts and icon bars. One way would be to disable the options but I have a
preference for leaving the options in place and just deleting the changes as
they exit. To do this I'm trying to delete Excel11.xlb as they exit but I
can't seem to get the code in the right place for it to trigger. One attempt
did in fact delete it only for a subsequent event in the closing excel
sequence of events to put it back. Has anyone any ideas on this?
--
Paul

--

Dave Peterson