Quick Access Toolbar File

[Mary Fetsch]

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]

Also with a shortcut it is not working Mary
I think it is not possible what you want

 

[iliace]

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.

 

[iliace]

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.

 

[Mary Fetsch]

I was just going through some posts I've done and realized I never thanked
you for yours. So thanks a lot!