Command Button Shrinkage

[Scooter172]

I have a spread sheet with several command buttons that run macros that are used for various tasks... when we hit them they will sometimes shrink. My thought is this is a memory issue. Any thoughts. :think:

[Simon Lloyd]

I can only imagine they shrink because of sheet formatting.......etc, or they are returning to a predefined size.

[shrivallabha]

While you are in the design mode:
1. Right click on the any control item, it will give options which includes 'Format Control'

2. In properties Tab, you should be able to do settings that you like.

See the Screen Dump.JPG

Hope this helps.

[Blade Hunter]

I get this as well, it annoys the hell out of me but I have noticed that it seems to be when I have not rebooted for a month or two and am running low on memory. A reboot ALWAYS fixes it for me, it's nothing to do with the formatting of the button.

Hope that helps (Although realistically it will not help at all but rather just tell you that yes you are not crazy and your sheet is doing weird things :p)

Cheers

Dan