Load Excel.xlb

[gabch]

Hi,

How to set default load same Excel.xlb for everyone login user.
e.g.,
C:\Documents and Settings\<Userlogin>\Application
Data\Microsoft\Excel.xlb
To
C:\Documents and Settings\All Users\Application
Data\Microsoft\Excel.xlb

Thx

 

[NickHK]

I believe you have to copy the desired .xlb to that location, as you cannot
edit this path.

NickHK

 

[Dave Peterson]

And remember if you force others to have the same toolbar as you, you'll be
destroying their own toolbar choices.

I wouldn't appreciate you doing this to me.

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)