Hi there,
Do you mean that you want the "Bigger Formula Bar" to stay in a fixed position? And the position should not be in the sheet but in the ribbon (see screenshot)?
Or you want the size of the "Bigger Formula Bar" to be fixed? - For this one, I think "Bigger Formula Bar" does not change its size when you close a sheet or switch tabs.
Amanda