Command buttons re-sizing randomly when a workbook is opened or activated
I have a workbook with 6 command buttons on the first worksheet. Normally they stay in place and retain their size but...
Sometimes (when the workbook is opened or activated) one or more buttons will get bigger e.g. the width goes from say 162 to 3999 or they reposition themselves or they disappear (could this be because the width or height becomes zero?)
The workshop open event causes the button's visibiilty to change dependent on the user- but not to re-size.
Any ideas as to how to avoid this would be very much appreciated!!