In my Excel application, I hide the FormulaBar (and ribbon, status bar, headings, scroll bar, etc.) using the following statement on Workbook Activate event:
Application.DisplayFormulaBar= False
Of course, I also have the opposite statement on the Workbook Deactivate event.

When I open the workbook, the formula bar hidden (which is good) but I now can't make any edits to cells!!!???

I can click on the cell and navigate from one cell to another using the keyboard or mouse and can even copy the values from the cells (and paste elsewhere) but I can't edit anything.
Clicking on the keyboard doesn't do anything, which is odd because the cells are not locked or anything.

The problem goes away when I make the formula bar visible again by manually checking the box under Excel options.
If I do this once, everything works fine again irrespective of whether the formula bar is visible or not.

Please help!
PS: The irony is I posted yesterday asking how I can achieve this effect (allow copy-paste without edits) for a different application and now Excel shows me it is possible, but when I don't want it and don't understand how / why it's happening. I'm almost convinced Excel is just toying with me!