If you're experiencing a disappearing status bar in Excel, there are a few possible explanations.
One possibility is that the status bar is turned off. To check if this is the case, go to File > Options > Advanced. Under Display options for this workbook, look for Show status bar. If it's unchecked, check it and click OK. This should make the status bar reappear.
Another possibility is that your worksheet is too small to display the status bar. To fix this, try increasing the size of your worksheet. You can do this by going to File > Page Setup > Sheet and changing the values under Print titles.
If neither of these solutions works, it's possible that your status bar has been customized and is now hidden. To check if this is the case, go to File > Options > Customize Ribbon. Under Main Tabs, look for the Developer tab. If it's checked, click OK. This will add the Developer tab to your ribbon, which you can use to access the Visual Basic Editor. In the Visual Basic Editor, go to Tools > References and look for Microsoft Excel Object Library. If it's not checked, check it and click OK. This will add a reference to the Excel object library, which you can use to access the status bar.
Once you've added the reference, go back to the Visual Basic Editor and select Insert > UserForm. This will insert a new UserForm into your workbook. In the UserForm code window, paste the following code:
Private Sub UserForm_Initialize() Dim myStatusBar As StatusBar Set myStatusBar = Application.StatusBar myStatusBar.Visible = True End Sub
This code will make the status bar visible when you open your workbook.