Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart Disappears | Charts and Charting in Excel | |||
dont see the name box on the toll bar | Excel Discussion (Misc queries) | |||
Text box disappears | Charts and Charting in Excel | |||
Textbox disappears | Charts and Charting in Excel | |||
How can I use Analysis Toll Pack functions in VBA? | Excel Programming |