Excel 2010 Command buttons moving and resizing

Farback

Board Regular
Joined
Mar 27, 2009
Messages
149
I have an Excel 2010 worksheet that has about 20 ActiveX Command Buttons. There are sections to the worksheet and all the buttons do is hide and unhide the sections. The buttons should hide with the sections they are on. Everything seemed to work fine for a while, but now, when a section is hidden, the buttons on it shrink to a thin sliver and move to the bottom or top of the page. I have the buttond set to 'Move and Size with cells' and as I say, this worked fine for a while. I was advised to change this to 'Move but don't Size with cells' but with this, the buttons don't hide when the section is hidden, they just sit on top of the worksheet.

Does anyone know how to 'lock' buttons to a cell or location, so they hide when the location is hidden and unhide when it is unhidden?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Make sure that the buttons don't overlap the cell. You can hold down Alt when positioning/sizing to snap to the grid.
 
Upvote 0

Farback

Board Regular
Joined
Mar 27, 2009
Messages
149
Hi Andrew. Yes, I've tried that, they are all centred within a cell not overlapping. I've tried Grouping them, which doesn't work either.
 
Upvote 0

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I can't reproduce what you are seeing in Excel 2010 sorry. Do you want to put your workbook on a share like Box.com and post the URL so that I can take a look?
 
Upvote 0

Farback

Board Regular
Joined
Mar 27, 2009
Messages
149
Andrew

Sorry, I can't do that due to the Company policy. I've had to use a work around as I need to get this completed, but thanks for the replies.
 
Upvote 0

Forum statistics

Threads
1,191,381
Messages
5,986,300
Members
440,017
Latest member
vasanrajeswaran

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
Top