Excel Macro Command Button Not Working

Anonymous
2019-07-03T11:53:39+00:00

Hi everyone,

I have a user who is unable to click command buttons in Excel sheets, but these same buttons work for other people.

When clicking the button a "ghost" of that button will appear in some location around it, and if that ghost intersects with the original button it can be clicked and the macro will run. See below for an example screenshot.

This user can run the macro manually, or with an associated keyboard shortcut, it is just the command buttons that do not work. We created a test worksheet on the user's machine and the macro button will not work, but sending the same file to my machine the button will work.

I have tried an online Office repair, checked macros are enabled, compared settings to my own but nothing seems out of place.

Any assistance with this would be much appreciated!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

12 answers

Sort by: Most helpful
  1. Anonymous
    2020-05-10T20:44:29+00:00

    I had same issue, found that its not issue with the dock, its with HDMI connection, when I remove the HDMI connection, it works perfectly. THe VBA executes when I click command button.

    10 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2020-06-29T11:54:55+00:00

    I agree that this is the problem. What happens on my set up is that if you click on a command button while connected via dock+hdmi the text just gets smaller and smaller and smaller and … All parts (apart from the display) are supplied by Microsoft.

    This is a major irritation, making Excel on a modern large display set-up unusable.

    9 people found this answer helpful.
    0 comments No comments