Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default How do I force a custom Excel Toolbar when starting Excel?

I created a custom tool bar with a lot of buttons and actions. It works great.

I need it to be there everytime Excel opens. And I want to do it for every
employee in the firm. I am the domain admin and a developer.

I can save it in my workbook. I can put the workbook in the XLStart folder.
I can even hide it. But how do I deploy it.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default How do I force a custom Excel Toolbar when starting Excel?

Dean

The customary method is to create the Toolbar "on the fly" by building it with
code when the workbook opens.

Save the workbook as an Add-in and distribute that add-in or have it stored
where all users can access it.

See Debra Dalgleish's site for code and a sample workbook.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP

On Sun, 14 Jan 2007 10:25:01 -0800, Dean E Brown <Dean E
wrote:

I created a custom tool bar with a lot of buttons and actions. It works great.

I need it to be there everytime Excel opens. And I want to do it for every
employee in the firm. I am the domain admin and a developer.

I can save it in my workbook. I can put the workbook in the XLStart folder.
I can even hide it. But how do I deploy it.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing custom toolbar from Excel 2003 [email protected] Excel Discussion (Misc queries) 0 July 14th 06 05:00 PM
Excel 2007 - Custom menus is missing! Søren Thade Petersen Excel Discussion (Misc queries) 3 July 11th 06 01:59 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel 2002 custom toolbars fick Excel Discussion (Misc queries) 4 December 13th 04 09:51 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM


All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"