Professor Excel

Comments 4

  1. Harold van Bolhuis

    Dear Henrik

    Thank you for the introduction.
    As I really liked your setup with the automatic and manual calculation options I added those to my QAT as well.
    However they are only shown with the green circle used standard for all special commands.
    As they are shown in your example as tick boxes, I downloaded your file and compared it to mine.
    The show exactly the same instruction. Can you tell me how to get those tick boxes? I am using Excel 2016.

    With kind regards,


    • Henrik Schiffner

      Hi Harold,
      I had the same problem. But if I remember correctly, after some updates of Microsoft Office it was gone and instead of those green circle tick boxes, it showed the correct description again. If you click on “File” and “About”, it shows the version number (e.g. “Version 1707”)? Version 1707 should be the latest version as of today.
      Does that help you?
      Best regards,

  2. Sal Veltri

    I have added a macro to the QAT. I would like to change the mouseover tip, it currently shows the name of the sub. I would like it to be more descriptive. Can this be done?,

  3. Richard

    Dear Henrick; I’m using Excel-2016 running on Windiws-10 (home, 64-bit). My problem is that sometimes Excel does show ALL (50 or so of) my “Quick Access Toolbar” shortcuts and sometimes it will show only some (maybe, 30 or so). Why does this annoyance happen and what can I do about it? When it show only some of the QAT shortcuts, the ones that do show are spread-out across the top of the screen with more blank-space in between the shortcuts. Thank you for any ideas you might have.

Leave a comment

%d bloggers like this: