Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default Toll bar disappears...

I have created a tool bar within EXCEL. The tools bar activates a number
of macros that are recorded in PERSONAL.XLS
Every once in a while the tool bar disappears and I have to reconstruct it.
Any idea why?
Where are tool bars "saved" when they are part of Excel?
Thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Toll bar disappears...

Toolbars, more correctly called Command Bars, are stored in your
xlb file. The exact name and location of this file depends on
your version of Excel and Windows. Search for a file named *.xlb
to find the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PCOR" wrote in message
.. .
I have created a tool bar within EXCEL. The tools bar
activates a number of macros that are recorded in PERSONAL.XLS
Every once in a while the tool bar disappears and I have to
reconstruct it. Any idea why?
Where are tool bars "saved" when they are part of Excel?
Thanks




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default Toll bar disappears...

I am using OFFICE 2003 version.
Are you saying that ALL the COMMAND Bars are located in that one *.xlb file?
Thanks

"Chip Pearson" wrote in message
...
Toolbars, more correctly called Command Bars, are stored in your xlb file.
The exact name and location of this file depends on your version of Excel
and Windows. Search for a file named *.xlb to find the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PCOR" wrote in message
.. .
I have created a tool bar within EXCEL. The tools bar activates a number
of macros that are recorded in PERSONAL.XLS
Every once in a while the tool bar disappears and I have to reconstruct
it. Any idea why?
Where are tool bars "saved" when they are part of Excel?
Thanks






  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Toll bar disappears...

User created command bars are stored in the xlb file, as are
modifications to the standard command bars.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PCOR" wrote in message
.. .
I am using OFFICE 2003 version.
Are you saying that ALL the COMMAND Bars are located in that
one *.xlb file?
Thanks

"Chip Pearson" wrote in message
...
Toolbars, more correctly called Command Bars, are stored in
your xlb file. The exact name and location of this file
depends on your version of Excel and Windows. Search for a
file named *.xlb to find the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PCOR" wrote in message
.. .
I have created a tool bar within EXCEL. The tools bar
activates a number of macros that are recorded in PERSONAL.XLS
Every once in a while the tool bar disappears and I have to
reconstruct it. Any idea why?
Where are tool bars "saved" when they are part of Excel?
Thanks








  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default Toll bar disappears...

Ok and thanks for the info

"Chip Pearson" wrote in message
...
User created command bars are stored in the xlb file, as are modifications
to the standard command bars.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PCOR" wrote in message
.. .
I am using OFFICE 2003 version.
Are you saying that ALL the COMMAND Bars are located in that one *.xlb
file?
Thanks

"Chip Pearson" wrote in message
...
Toolbars, more correctly called Command Bars, are stored in your xlb
file. The exact name and location of this file depends on your version
of Excel and Windows. Search for a file named *.xlb to find the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PCOR" wrote in message
.. .
I have created a tool bar within EXCEL. The tools bar activates a
number of macros that are recorded in PERSONAL.XLS
Every once in a while the tool bar disappears and I have to reconstruct
it. Any idea why?
Where are tool bars "saved" when they are part of Excel?
Thanks












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
Chart Disappears MSCH Programmer Charts and Charting in Excel 0 November 12th 09 02:43 PM
dont see the name box on the toll bar usya sterm Excel Discussion (Misc queries) 3 January 26th 06 08:37 PM
Text box disappears Suenapky Charts and Charting in Excel 0 December 8th 05 06:35 PM
Textbox disappears B. Scace Charts and Charting in Excel 2 August 29th 05 11:59 PM
How can I use Analysis Toll Pack functions in VBA? Torbjörn Lindström Excel Programming 3 September 2nd 04 02:58 AM


All times are GMT +1. The time now is 09:00 PM.

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

About Us

"It's about Microsoft Excel"