Re: Quick Access Toolbar File

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 <iasaf...@xxxxxxxxx> 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 <MaryFet...@xxxxxxxxxxxxxxxxxxxxxxxxx>
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 -



.

Relevant Pages

  • Re: "Access is denied."
    ... The 5 tabs I have are: ... Tools, Hardware, Sharing and Quota. ... "Allow network users to change my files" ... instructs me to drag the folder to the "Shared documents" folder. ...
    (microsoft.public.windowsxp.general)
  • Re: Quick Access Toolbar File
    ... you'll also have to rewrite all your standard tabs. ... drive and reference it from there? ... 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. ...
    (microsoft.public.excel.misc)
  • Re: Epiphany Shortcut problem
    ... Don't worry about it Ben, ... folder, I couldn't any reference to new tabs. ...
    (uk.comp.os.linux)
  • Re: Emailing web form information to me
    ... To deal with your comments on Vista, it is the mapping via 'my computer' ... or indeed the other bug that causes Publisher to ... have a default folder such as "public_html" that you are supposed to upload ... In the Map Network Drive dialog box, ...
    (microsoft.public.publisher.webdesign)
  • Re: Imagining/Cloning Desktops
    ... Via Network you'll have 2 requirements. ... has an account that has full permissions on it. ... local user account on the ghost storage pc and give it full access only ... source files set and the network drivers copied into the folder burn ...
    (microsoft.public.windowsxp.setup_deployment)