Share via

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

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-18T18:35:41+00:00

    Turns out it was the external monitor and had something to do with auto-sizing when I dragged the spreadsheet to the external monitor.  Only fix is to just leave that spreadsheet on the laptop and not drag it over.

    60 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-02-19T08:10:22+00:00

    We never did find a solution for this as we replaced the documents using the macro buttons.

    The external monitor at a different DPi does sound likely as this user had a 13" laptop at probably 150% scaling connected to a larger monitor at 100%.

    8 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-03-16T17:41:23+00:00

    I found this thread after experiencing the same problem.  That is, my ActiveX Command buttons can't be activated.  I just get a "ghost" version elsewhere when I press the button.  I confirmed that the Command buttons work when undocked.  Deleting buttons and re-creating them doesn't help.

    Changing to Forms buttons fixed the problem

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2020-03-16T18:17:58+00:00

    I found that it was related to a recent update. I repaired the update,  rebooted & it was fine. I did have to create my button again though.

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2020-03-21T09:49:18+00:00

    I had the same issue. Working with Excel 365 MSO 64 Bit, 16.0.12527.20260 on Win10 Pro.

    I created a simple macro with an ActiveX button month ago.

    Simple quick click on the button did not work yesterday, the button solely looked like pressed down (maybe a shadow button?) but no action. After next click somewhere in the sheet the button became as usual again.

    After that, I tried to click and hold down the button for 2-3 seconds and it worked.

    Since then, it works normally again, even after restarting Excel.

    1 person found this answer helpful.
    0 comments