In an Excel 2010 worksheet with command buttons set to "Move and Size with Cells", if you hide the columns they are in (which also hides the buttons), then save and close the workbook, when you reopen the workbook and unhide the columns, the button widths remain at 0, making them invisible. The problem will not show up until you have closed and reopened the workbook. If you save it with the columns hidden, then unhide them, the buttons reappear as they should, but then if you close (without saving) and reopen the workbook, they're gone.

The only way to show them, other than resetting the width with code, is to go to design mode, select another button or object, and hit Tab until it lands on the hidden object. Then you can drag it wider.

My app does a lot of column hiding & unhiding, as well as saving and routing through Outlook with attachments, so I don't see a reasonable VBA solution. Whenever it unhides columns it would have to loop through all the objects, try to determine if any were in the hidden columns, and then somehow determine what the original width was. I suppose it's doable, but not reasonable or acceptable in my opinion.

Has anyone encountered this? Is there a reasonable workaround or solution to this bug?
It's not a problem in 2003 where I developed the app, but even if I create new buttons in 2010 and save it as a .xlsm, it still does the same thing. I took half a day digging through my code because I thought it was a VBA problem, but finally realized I could reproduce it manually. I would really appreciate some help with this.