I have this problem and I hope someone could help me.
I have a spredsheet with several command buttons.
On the first sheet I have a block for first rows and columns.
Because of first sheet has about 150 rows and 400 columns, I need to block first rows and columns.
Well, sometimes, (not always), when I click on a command button that shows a Userform, the entire page below is enlarged. When I close Userform, entire blocks of cells disappear.
In this case, I have to close the workbook or to turn off the block of the rows.
In fact, If a turn off the block of the first rows and columns, problem instantly disappears.
Does someone know how to fix this problem?
I tried turning off block of rows and columns