qat

Hello, Can anyone help to get the idMso for superscript and subscript in excel ? I have tried below code, but this is not working.... <button idMso="Superscript" size="normal" />

I have always had the mathematic operators in my QAT (+ - * / = etc). I now have Excel 2019 on Mac and I can't find anyway of adding the to my QAT. Your article Excel 2019: Customize the Quick Access Toolbar says it can be done. Please expand on how to find them to add. Thx

Hi! :biggrin: I have questions about QAT. 1. How do I add my `tooltip` to a button. How do I add a tooltip to any button? 2. How to change the icon of the button `White Arrow`? 3. How to insert my own icons? 4. Is it possible to add more `Submenu`. For example `Submenus_1`...

Over the years I have developed a really nice QAT that makes my work so much faster. I know that QATs can be moved around and so I'd like to use my work QAT at home. However, I'm finding that any button attached to a macro also carries with it its path. When I go to use that button at home I...

I'm adding UDF macros into Personal but they neither show up on worksheets when I start typing =nameoftheUDF nor in the QAT under macros. What's going on? Thanks **UPDATE*** looks like competing "Personal" files

I have the following XML Code to present the user with UNDO & REDO QAT Options in my workbook The commands and buttons do work - However I am only able to UNDO (or REDO) 1 level back - I was hoping to get several UNDOs if needed Not sure how many are provided in standard Excel Ribbon but I...

Hi I've just started using Xl2013. Whenever I select a range it gives an icon on the lower right to access quick analysis functions. Most of the tables I select have a total right where this icon appears so I can't see the total changing for example if I paste new formulas. Can I turn it off...

I'm delighted that it is now possible to customise the QAT, and even more that it is possible to trigger macros from the QAT. However, every macro I add uses, by default, a generic circle as its icon. I need to trigger at least 20 different macros using QAT. How can I customise each one's icon...

Hello guys, here are my specs: Lenovo laptop with WIN7 64 Bit Office 365 Home English Slovak Keyboard Layout (so I have to press "shift" key in order to type a number; otherwise if I press "1" i get "+" sign, if I press "2", I get "ľ" sign and so on) here is my problem: When I want to use...

Hi all, Would anybody please give me a brief explanation as to what the Excel.officeUI file actually is .. And can it be created in office 2007 or is it only possible in office 2010 and later ? Should it be located in the same folder as the Excel.qat ? Regards.

Hi All, I have done all the necessary in CustomUI and the VBA; mapping the custom calls to VBA functions. Now the major pain the neck is, the small mischievous Down-Arrow BUTTON ( called as Customize Quick Access Toolbar ) on the TOP LEFT on the title bar of EXCEL, using which anyone can...

on my pc I have an icon on the qat which invokes a macro in PERSONAL.XLSB I can't see how to get this to work on a mac. Is there even a qat on Mac? Grateful for any help. thanks

I've developed a fairly simple procedure which lets me reformat cell backgrounds in a worksheet after various cut/paste operations. I've created a template called BASIC.XLTM which has this code in it. I've added a button to the QAT to enable me to invoke the procedure, but when I click the...

I'd like to have my QAT give me 2 rows--a word wrap sort of view. If I add more buttons than there is room I get the >> symbol saying there are more controls---this becomes multi clicks to get to the macro buttons Is there anyway to force excel to add another row and keep showing the...

I know how to put items on the QAT. I see the icons they show me to choose from when addding one. up until now I have been using those. However, I wonder if there is a way to have other icons usable on the QAT? for example: right now I have 6 macros tied to the QAT. each one has a...

how can i backup [export] my QAT? where are the settings stored? excel 2010

Does anyone know of a supplemental symbol pack for Excel 2010, for use when modifying buttons in the QAT?