This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
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.
I have the same issue. There appears to be a bug. I read in another forum that if you use a docking stations (as I do), I should remove my laptop from the dock and try again. Low and behold the buttons worked again. [I redocked and they are currently still working].
MSFT can you please address this bug.
[Edit] . Okay, once redocked buttons fail to work again. - Current (unexceptable) solution, only access files with command buttons 'undocked'.
The text 'CommandButton1' in the original post suggests to me that Sam (maybe others?) might be using an ActiveX button instead of a Forms button (which I'd expect to have the default label of "Button 1"). I'd suggest trying a forms button, and testing with the same user(s) to see if that avoids the problem.
I gave up using all ActiveX controls in my projects years ago because of how squirrely they are, especially when trying to deploy and maintain over multiple end users (all with machines with slightly different configurations). My issues were more around functionality and unexpected machine crashes, so your mileage may vary...
Just something worth trying, since it looks like this thread has been open a while and keeps getting new hits. If the folks on this thread reply saying they are also experiencing the same issue with forms buttons, then I'm out of ideas...
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.
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.