Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time.
Nothing in the code is instructing this.
Has anybody else experienced this joy?
+2
A:
Could it be that the button is defined to stick to the corners of a cell, instead of floating freely ?
Check it with
Format | Properties | Object Positioning
and choose anything but "move and size with cells"
PA
2009-10-15 16:14:27
tried it, but unfortunately it didn't work - the controls still have a mind of their own!
Nick
2009-10-22 17:13:24
I'll confess - the person who "tried" it, didn't save it down properly. This does in fact work!
Nick
2009-11-06 10:46:50
It had to be the third option, don't move or size with cells...
Nick
2009-11-06 10:47:24
A:
I've seen this behaviour, particularly with radio buttons shrinking, but never understood why it happens, why it only happens sometimes, or how it can be fixed. Just assumed it was a bug.
Lunatik
2009-10-16 06:31:52