When I click a Button (Form Control) on my spreadsheet to run a macro, sometimes it shrinks, and even nearby buttons shrink.

jerry12302

Active Member
Joined
Apr 18, 2005
Messages
458
Office Version
  1. 2010
Platform
  1. Windows
I have Buttons (Form Control) on my spreadsheet to run various macros. Sometimes when I click on one it shrinks to a tiny size, and sometimes even nearby buttons shrink at the same time. The macro runs OK.

I have to right click them afterward, expand them back to normal, and reposition them on my spreadsheet.

I try to remember to save my file first every time I need to click a button so I can close and open the file again if it happens, and try again.

Does anyone else ever experience this?
 
I have seen this with ActiveX controls when I am using a laptop with a second external monitor. I have never seen it with Form controls, and often people recommend using Form controls to solve this problem.

What hardware setup are you using?
 
Upvote 0
I have seen this with ActiveX controls when I am using a laptop with a second external monitor. I have never seen it with Form controls, and often people recommend using Form controls to solve this problem.

What hardware setup are you using?

A Dell PC, Windows 7, Office 2010.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top