At the moment, I'm just creating the toolbar and buttons on each
user's PC (only three of them.) I suppose the XLB question is a bit
moot since, even when the toolbar does appear the buttons don't work
anyway.

Thanks for the help. :-)

Just had a thought, the buttons will point to C:\...myusername\app data
\microsoft etc etc etc... For it to work on their PC, it'll need to
point to their username folder in Documents and Settings... Mmm... I
wonder if you can deallocate a button's attributes (take the macro
away) then re-add...

I've redone the buttons anyway but I hate to get beaten... :-|

Thanks again.





On 6 Feb, 13:30, Dave Peterson wrote:
First, I agree with what Bob wrote.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

======
My guesses (and only guesses) on the other stuff...

A. The user may not have write permission to that folder.
The *.xlb file could be marked readonly.
Excel could be working fine and saving the *.xlb file.

But the user could have other *.xlb files that open after the updated file gets
open. The last *.xlb file that opens will be the one you see. But it may not
be the one that gets updated when excel closes.

I'd search for all the *.xlb files (look in hidden folders, too!) and
move/delete them to a safe spot and then see what happens.

B. Yep. If the workbook assigned to that button isn't open, then excel will
try to open it. And if the user is prompted and allows macros to run (or has a
"nice" security setting), then the macro will run.

The bad news is that if that button points to a different location on the user's
pc than on your pc, then there could be major trouble.

That's why Bob recommends building the toolbar on the fly.