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


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=572531

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

NickHK

"gabch" wrote in
message ...

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


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=572531

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)

gabch wrote:

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

--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=572531

--

Dave Peterson