Is this a 2013 bug? Or is it me?

[scenario]

My file works in 2010 but not in 2013. Is it a bug or is it me? Any ideas?


I created a financial calculator using simple VBA and ActiveX controls that works perfectly when opened in Excel 2010, but not in 2013. I am looking for any thoughts regarding the problem which I will describe in more detail below.

Summary:
(1) I have ActiveX spin controls linked to most of my number input cells.
(2) I have VBA code to start the spreadsheet in full screen mode.

Problem:
When I open the file in Excel 2013, I can enter data into cells UNTIL I use the spin controls. Once I use any of the spin controls, I lose the ability to type values into the cells. It's as if the cells are locked (they are not).

Notes:
(1) My original workbook had multiple tabs, macros, etc. but... I have been able to replicate the problem in a simple demo spreadsheet (picture below) with one value, one spin control, and one line of code in Workbook_Activate.
(2) The problem does not occur in Excel 2010, only 2013.
(3) I have also been able to replicate the problem with other lines of code in either Workbook_Activate or Workbook_Open. The lines of code involved maximizing the screen, hiding scrollbars, hiding tabs, hiding the command bar, and others.

Attachments:
- I am including screen shots of my simple demo file below. One showing the single input with spin control; the other showing the simple line of code in This Workbook/Workbook_Activate.

Any thoughts on this are greatly appreciated.
In a perfect world, the problem will be the result of a simple mistake on my part that you will be able to correct me on quickly.

Thanks in advance.

 

[circledchicken]

Hi,

I suggested the alternative to full screen in posts #10 and #17...

Anyway, after a bit of experimenting, here's a 'trick' that might help (momentarily display then hide the formula bar):

Private Sub Workbook_Activate()
    With Application
        .ScreenUpdating = False
        ' full screen alternative
        .ExecuteExcel4Macro "Show.ToolBar(""Ribbon"", false)"
        .DisplayStatusBar = False
        ' ...
        ' your other code
        ' ...
        ' the 'trick'
        .DisplayFormulaBar = True
        .DisplayFormulaBar = False
        .ScreenUpdating = True
    End With
End Sub

Although I think you should just revert to form controls (at the expense of the extra work) or do something else/simpler rather than messing around with this buggy functionality.