I have a single worksheet that contains a condensed report area beginning in column BA and a data entry area beginning on Column A.
There is a user form command button on each that runs a macro to let user flip between the two. Column A in the data entry area is a frozen column.
After clicking the command button on the data entry area to go to the report area the original command button on the report changes from standard button appearance to just text with an oval line around it. No button outline or background fill. When you click on it, it suddenly shrinks to a tiny button in the upper left corner of its cell. The size parameters also change from normal to Height .04" and Width .29". This behavior is consistent even after changing the button text to one word vs. the normal 3.
On the other hand if I select the shrunken button and expand it back to its original size, the original (normal) button appearance returns and the button functions normally. While I might expect odd behavior from memory problems, this behavior remains even after rebooting. I have tested this on two different PCs with the same result.
Varying the properties does not seem to have an effect. The relevant properties are:
Print Object
Don't move or size with cells
and Alignment: "Automatic Size" is not checked
Size: "Lock Aspect Ratio" is not checked
Margins: "Automatic" is checked
I have similar worksheets in the same workbook and the result is the same on each. Strange -Can anyone help?
-------------------------------------------------------------------------------------------------------------------
12/30/2013
SOLVED!!!!!
Thanks to everyone for your guidance. Here's what I have found after further tests...
1. The resizing issue occurs on both Form command buttons and Active X.
2. The resizing of command buttons will only occur after printing a selection from the worksheet. It will then resize (shrink) only after pageup/down or several clicks on various portions of the same worksheet.
3. Confirmed that this is an apparent bug - not a function of code.
4. Solution: I switched from a command button and inserted a rectangle shape instead. Set its properties to look like a command button and attached the proper macros to it. This completely cured the problem and eliminated the need to have a special macro to temporarily resize the button. Everything is now nice and clean and stable. Repeated for the 3 buttons on the worksheet.
Again thanks to all !!
Bookmarks