ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Quick Access Toolbar File (https://www.excelbanter.com/excel-discussion-misc-queries/164783-quick-access-toolbar-file.html)

Mary Fetsch
Quick Access Toolbar File
 
Is there any way to store the Excel.qat (custom toolbar) file on my network
drive and reference it from there? I've done that with my personal.xlsb
macro file by removing it from my C drive and placing it on my network drive
in a folder that I've designated as my Excel startup folder. (That way it
gets backed up up regularly with all my other network files.)

I tried to do the same thing with the Excel.qat file, but it's not
referencing it as my toolbar. It's just opening it as a file.

I'll appreciate any help you can give me on this.

Mary Fetsch

Ron de Bruin
Quick Access Toolbar File
 
Also with a shortcut it is not working Mary
I think it is not possible what you want

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mary Fetsch" wrote in message ...
Is there any way to store the Excel.qat (custom toolbar) file on my network
drive and reference it from there? I've done that with my personal.xlsb
macro file by removing it from my C drive and placing it on my network drive
in a folder that I've designated as my Excel startup folder. (That way it
gets backed up up regularly with all my other network files.)

I tried to do the same thing with the Excel.qat file, but it's not
referencing it as my toolbar. It's just opening it as a file.

I'll appreciate any help you can give me on this.

Mary Fetsch

iliace
Quick Access Toolbar File
 
Create an XLAM file with a custom ribbon, using
startFromScratch="true" in the <ribbon tag. Now, you'll be able to
customize your QAT between the <qat and </qat tags. For instance,
this is mine:

<qat
<control idMso="FileNewDefault" visible="false"/
<control idMso="FilePrintQuick" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="Spelling" visible="false" insertBeforeQ="FileOpen"/
<control idMso="SortAscendingExcel" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="SortDescendingExcel" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="FileNew" visible="true" insertBeforeQ="FileOpen"/
<control idMso="FileOpen" visible="true"/
<control idMso="FileSave" visible="true"/
<control idMso="FilePrint" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="FilePrintPreview" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="PageSetupPageDialog" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="FileSendAsAttachment" visible="true"/
<control idMso="ViewFreezePanesGallery" visible="true"
insertBeforeQ="Undo"/
<control idMso="GroupPageLayoutScaleToFit" visible="true"
insertBeforeQ="Undo"/
<control idMso="PivotTableInsert" visible="true" insertBeforeQ="Undo"/

<control idMso="MacroPlay" visible="true" insertBeforeQ="Undo"/
<control idMso="Undo" visible="true"/
<control idMso="Redo" visible="true"/
<control idMso="ZoomCurrent100" visible="true"/
<control idMso="CellFillColorPicker" visible="true"/
<control idMso="FontColorPicker" visible="true"/
<control idMso="SpeakCells" visible="true"/
<control idMso="SpeakStop" visible="true"/
</qat

Unfortunately, you'll also have to rewrite all your standard tabs.
This might be more of a problem, because you'll have redefine each
tab, plus put the groups in the correct order (which I didn't do
below):

<tabs
<tab id="TabHomeMyCustom" label="Home"
<group idMso="GroupAlignmentExcel" /
<group idMso="GroupCells" /
<group idMso="GroupClipboard" /
<group idMso="GroupEditingExcel" /
<group idMso="GroupFont" /
<group idMso="GroupNumber" /
<group idMso="GroupStyles" /
</tab
<tab id="TabInsertMyCustom" label="Insert"
<group idMso="GroupInsertBarcode" /
<group idMso="GroupInsertChartsExcel" /
<group idMso="GroupInsertIllustrations" /
<group idMso="GroupInsertLinks" /
<group idMso="GroupInsertTablesExcel" /
<group idMso="GroupInsertText" /
</tab
<tab id="TabPageLayoutExcelMyCustom" label="Page Layout"
<group idMso="GroupArrange" /
<group idMso="GroupPageLayoutScaleToFit" /
<group idMso="GroupPageLayoutSheetOptions" /
<group idMso="GroupPageSetup" /
<group idMso="GroupThemesExcel" /
</tab
<tab id="TabFormulasMyCustom" label="Formulas"
<group idMso="GroupCalculation" /
<group idMso="GroupFormulaAuditing" /
<group idMso="GroupFunctionLibrary" /
<group idMso="GroupNamedCells" /
</tab
<tab id="TabDataMyCustom" label="Data"
<group idMso="GroupConnections" /
<group idMso="GroupDataTools" /
<group idMso="GroupGetExternalData" /
<group idMso="GroupOutline" /
<group idMso="GroupSortFilter" /
</tab
<tab id="TabReviewMyCustom" label="Review"
<group idMso="GroupChangesExcel" /
<group idMso="GroupComments" /
<group idMso="GroupInk" /
<group idMso="GroupProofing" /
</tab
<tab id="TabViewMyCustom" label="View"
<group idMso="GroupMacros" /
<group idMso="GroupViewShowHide" /
<group idMso="GroupWindow" /
<group idMso="GroupWorkbookViews" /
<group idMso="GroupZoom" /
</tab
<tab id="TabDeveloperMyCustom" label="Developer"
<group idMso="GroupCode" /
<group idMso="GroupControls" /
<group idMso="GroupModify" /
<group idMso="GroupXml" /
</tab
</tabs


I haven't found a way to refer to stock Excel tabs by their idMso to
get it to work, but this method is tolerable. But regardless, if you
have this in your network XLSTART folder as CustomInterface.xlam, both
your ribbon customizations and QAT customizations will be backed up as
you want.



On Nov 5, 10:41 am, Mary Fetsch
wrote:
Is there any way to store the Excel.qat (custom toolbar) file on my network
drive and reference it from there? I've done that with my personal.xlsb
macro file by removing it from my C drive and placing it on my network drive
in a folder that I've designated as my Excel startup folder. (That way it
gets backed up up regularly with all my other network files.)

I tried to do the same thing with the Excel.qat file, but it's not
referencing it as my toolbar. It's just opening it as a file.

I'll appreciate any help you can give me on this.

Mary Fetsch

iliace
Quick Access Toolbar File
 
Sorry - also need the office menu, if you do want to go this route.
This goes within the <ribbon tags, on the same level as <qat and
<tabs:

<officeMenu
<control idMso="FileSaveAsMenu" visible="true" /
<control idMso="FilePrintMenu" visible="true" /
<control idMso="FileSendMenu" visible="true" /
<control idMso="Close" visible="true" /
</officeMenu

Along those lines. New, Open, and Save are there by default.


On Nov 5, 1:35 pm, iliace wrote:
Create an XLAM file with a custom ribbon, using
startFromScratch="true" in the <ribbon tag. Now, you'll be able to
customize your QAT between the <qat and </qat tags. For instance,
this is mine:

<qat
<control idMso="FileNewDefault" visible="false"/
<control idMso="FilePrintQuick" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="Spelling" visible="false" insertBeforeQ="FileOpen"/
<control idMso="SortAscendingExcel" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="SortDescendingExcel" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="FileNew" visible="true" insertBeforeQ="FileOpen"/<control idMso="FileOpen" visible="true"/

<control idMso="FileSave" visible="true"/
<control idMso="FilePrint" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="FilePrintPreview" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="PageSetupPageDialog" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="FileSendAsAttachment" visible="true"/
<control idMso="ViewFreezePanesGallery" visible="true"
insertBeforeQ="Undo"/
<control idMso="GroupPageLayoutScaleToFit" visible="true"
insertBeforeQ="Undo"/
<control idMso="PivotTableInsert" visible="true" insertBeforeQ="Undo"/

<control idMso="MacroPlay" visible="true" insertBeforeQ="Undo"/
<control idMso="Undo" visible="true"/
<control idMso="Redo" visible="true"/
<control idMso="ZoomCurrent100" visible="true"/
<control idMso="CellFillColorPicker" visible="true"/
<control idMso="FontColorPicker" visible="true"/
<control idMso="SpeakCells" visible="true"/
<control idMso="SpeakStop" visible="true"/
</qat

Unfortunately, you'll also have to rewrite all your standard tabs.
This might be more of a problem, because you'll have redefine each
tab, plus put the groups in the correct order (which I didn't do
below):

<tabs
<tab id="TabHomeMyCustom" label="Home"
<group idMso="GroupAlignmentExcel" /
<group idMso="GroupCells" /
<group idMso="GroupClipboard" /
<group idMso="GroupEditingExcel" /
<group idMso="GroupFont" /
<group idMso="GroupNumber" /
<group idMso="GroupStyles" /
</tab
<tab id="TabInsertMyCustom" label="Insert"
<group idMso="GroupInsertBarcode" /
<group idMso="GroupInsertChartsExcel" /
<group idMso="GroupInsertIllustrations" /
<group idMso="GroupInsertLinks" /
<group idMso="GroupInsertTablesExcel" /
<group idMso="GroupInsertText" /
</tab
<tab id="TabPageLayoutExcelMyCustom" label="Page Layout"
<group idMso="GroupArrange" /
<group idMso="GroupPageLayoutScaleToFit" /
<group idMso="GroupPageLayoutSheetOptions" /
<group idMso="GroupPageSetup" /
<group idMso="GroupThemesExcel" /
</tab
<tab id="TabFormulasMyCustom" label="Formulas"
<group idMso="GroupCalculation" /
<group idMso="GroupFormulaAuditing" /
<group idMso="GroupFunctionLibrary" /
<group idMso="GroupNamedCells" /
</tab
<tab id="TabDataMyCustom" label="Data"
<group idMso="GroupConnections" /
<group idMso="GroupDataTools" /
<group idMso="GroupGetExternalData" /
<group idMso="GroupOutline" /
<group idMso="GroupSortFilter" /
</tab
<tab id="TabReviewMyCustom" label="Review"
<group idMso="GroupChangesExcel" /
<group idMso="GroupComments" /
<group idMso="GroupInk" /
<group idMso="GroupProofing" /
</tab
<tab id="TabViewMyCustom" label="View"
<group idMso="GroupMacros" /
<group idMso="GroupViewShowHide" /
<group idMso="GroupWindow" /
<group idMso="GroupWorkbookViews" /
<group idMso="GroupZoom" /
</tab
<tab id="TabDeveloperMyCustom" label="Developer"
<group idMso="GroupCode" /
<group idMso="GroupControls" /
<group idMso="GroupModify" /
<group idMso="GroupXml" /
</tab
</tabs

I haven't found a way to refer to stock Excel tabs by their idMso to
get it to work, but this method is tolerable. But regardless, if you
have this in your network XLSTART folder as CustomInterface.xlam, both
your ribbon customizations and QAT customizations will be backed up as
you want.

On Nov 5, 10:41 am, Mary Fetsch
wrote:



Is there any way to store the Excel.qat (custom toolbar) file on my network
drive and reference it from there? I've done that with my personal.xlsb
macro file by removing it from my C drive and placing it on my network drive
in a folder that I've designated as my Excel startup folder. (That way it
gets backed up up regularly with all my other network files.)

I tried to do the same thing with the Excel.qat file, but it's not
referencing it as my toolbar. It's just opening it as a file.

I'll appreciate any help you can give me on this.

Mary Fetsch- Hide quoted text -

- Show quoted text -

Mary Fetsch
Quick Access Toolbar File
 
I was just going through some posts I've done and realized I never thanked
you for yours. So thanks a lot!

"iliace" wrote:

Sorry - also need the office menu, if you do want to go this route.
This goes within the <ribbon tags, on the same level as <qat and
<tabs:

<officeMenu
<control idMso="FileSaveAsMenu" visible="true" /
<control idMso="FilePrintMenu" visible="true" /
<control idMso="FileSendMenu" visible="true" /
<control idMso="Close" visible="true" /
</officeMenu

Along those lines. New, Open, and Save are there by default.


On Nov 5, 1:35 pm, iliace wrote:
Create an XLAM file with a custom ribbon, using
startFromScratch="true" in the <ribbon tag. Now, you'll be able to
customize your QAT between the <qat and </qat tags. For instance,
this is mine:

<qat
<control idMso="FileNewDefault" visible="false"/
<control idMso="FilePrintQuick" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="Spelling" visible="false" insertBeforeQ="FileOpen"/
<control idMso="SortAscendingExcel" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="SortDescendingExcel" visible="false"
insertBeforeQ="FileOpen"/
<control idMso="FileNew" visible="true" insertBeforeQ="FileOpen"/<control idMso="FileOpen" visible="true"/

<control idMso="FileSave" visible="true"/
<control idMso="FilePrint" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="FilePrintPreview" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="PageSetupPageDialog" visible="true"
insertBeforeQ="FileSendAsAttachment"/
<control idMso="FileSendAsAttachment" visible="true"/
<control idMso="ViewFreezePanesGallery" visible="true"
insertBeforeQ="Undo"/
<control idMso="GroupPageLayoutScaleToFit" visible="true"
insertBeforeQ="Undo"/
<control idMso="PivotTableInsert" visible="true" insertBeforeQ="Undo"/

<control idMso="MacroPlay" visible="true" insertBeforeQ="Undo"/
<control idMso="Undo" visible="true"/
<control idMso="Redo" visible="true"/
<control idMso="ZoomCurrent100" visible="true"/
<control idMso="CellFillColorPicker" visible="true"/
<control idMso="FontColorPicker" visible="true"/
<control idMso="SpeakCells" visible="true"/
<control idMso="SpeakStop" visible="true"/
</qat

Unfortunately, you'll also have to rewrite all your standard tabs.
This might be more of a problem, because you'll have redefine each
tab, plus put the groups in the correct order (which I didn't do
below):

<tabs
<tab id="TabHomeMyCustom" label="Home"
<group idMso="GroupAlignmentExcel" /
<group idMso="GroupCells" /
<group idMso="GroupClipboard" /
<group idMso="GroupEditingExcel" /
<group idMso="GroupFont" /
<group idMso="GroupNumber" /
<group idMso="GroupStyles" /
</tab
<tab id="TabInsertMyCustom" label="Insert"
<group idMso="GroupInsertBarcode" /
<group idMso="GroupInsertChartsExcel" /
<group idMso="GroupInsertIllustrations" /
<group idMso="GroupInsertLinks" /
<group idMso="GroupInsertTablesExcel" /
<group idMso="GroupInsertText" /
</tab
<tab id="TabPageLayoutExcelMyCustom" label="Page Layout"
<group idMso="GroupArrange" /
<group idMso="GroupPageLayoutScaleToFit" /
<group idMso="GroupPageLayoutSheetOptions" /
<group idMso="GroupPageSetup" /
<group idMso="GroupThemesExcel" /
</tab
<tab id="TabFormulasMyCustom" label="Formulas"
<group idMso="GroupCalculation" /
<group idMso="GroupFormulaAuditing" /
<group idMso="GroupFunctionLibrary" /
<group idMso="GroupNamedCells" /
</tab
<tab id="TabDataMyCustom" label="Data"
<group idMso="GroupConnections" /
<group idMso="GroupDataTools" /
<group idMso="GroupGetExternalData" /
<group idMso="GroupOutline" /
<group idMso="GroupSortFilter" /
</tab
<tab id="TabReviewMyCustom" label="Review"
<group idMso="GroupChangesExcel" /
<group idMso="GroupComments" /
<group idMso="GroupInk" /
<group idMso="GroupProofing" /
</tab
<tab id="TabViewMyCustom" label="View"
<group idMso="GroupMacros" /
<group idMso="GroupViewShowHide" /
<group idMso="GroupWindow" /
<group idMso="GroupWorkbookViews" /
<group idMso="GroupZoom" /
</tab
<tab id="TabDeveloperMyCustom" label="Developer"
<group idMso="GroupCode" /
<group idMso="GroupControls" /
<group idMso="GroupModify" /
<group idMso="GroupXml" /
</tab
</tabs

I haven't found a way to refer to stock Excel tabs by their idMso to
get it to work, but this method is tolerable. But regardless, if you
have this in your network XLSTART folder as CustomInterface.xlam, both
your ribbon customizations and QAT customizations will be backed up as
you want.

On Nov 5, 10:41 am, Mary Fetsch
wrote:



Is there any way to store the Excel.qat (custom toolbar) file on my network
drive and reference it from there? I've done that with my personal.xlsb
macro file by removing it from my C drive and placing it on my network drive
in a folder that I've designated as my Excel startup folder. (That way it
gets backed up up regularly with all my other network files.)

I tried to do the same thing with the Excel.qat file, but it's not
referencing it as my toolbar. It's just opening it as a file.

I'll appreciate any help you can give me on this.

Mary Fetsch- Hide quoted text -

- Show quoted text -


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com