I have several commandbuttons on a worksheet residing within rows which are sometimes filtered out and sometimes included in what the filter shows. This works fine in Excel 2007. However, one of my PCs which uses the workbook is on Excel 2010, and Excel 2010 automatically collapses the commandbuttons when their rows are filtered out, so that the next time their row is filtered in the commandbuttons cannot be seen. (If you hover over their location, it is possible to find them and restore them from 0 height to their previous height.)
Does anyone have a solution in how to filter a row which includes a commandbutton without collapsing the commandbutton? I don't want the commandbutton to be visible when the row is filtered out.
Bookmarks