Is this a 2013 bug? Or is it me?

[Patrick Sullivan]

I created a financial calculator that uses 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 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 attaching both screen shots and the demo file.
- I figured I'd add the screen shots in case someone was hesitant to download the demo file since it is macro-enabled. (there is nothing dangerous in the demo file as you'll be able to see in the screen shots).

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.

 

[Hui]

Patrick

One of the main rules here is about Cross Posting.
http://social.technet.microsoft.com...ex-spin-button-broken-spreadsheet?forum=excel

Can you please read: http://chandoo.org/forum/threads/new-users-please-read.294/

Cross posting doesn't guarantee you a faster result, as people will now assume that someone at the other site will look after you, of course they will be assuming the same.

 

[Patrick Sullivan]

Hi. I'm not trying to cause any problems. I wasn't getting any responses. So, I posted on a few other sites. I wasn't assuming people from this forum would be viewing my post on other sites. I was more concerned no one would see it! I finally ended up calling Microsoft Technical Support today asking for help and they were the ones who told me to post it on TechNet. I'm just looking for help on this issue so I can fix a problem for a client in a timely manner. That's all.

 

[Hui]

When cross posting, be honest and let people know that you have cross-posted and where you have
eg: Microsoft Technet and Linkedin EHA group

 

[Hui]

It was discussed here in July '13: http://answers.microsoft.com/en-us/...een-true/5d1bd75f-ac0e-4dbe-bebe-5d318e34eda6
Without resolution?

 

[Patrick Sullivan]

I read the July 2013 post above. Thanks. Yes it appears unresolved. A few more notes...

The problem I'm having is not just with Workbook_Activate. It also occurs with Workbook_Open.

And I have no problem entering data in cells after the spreadsheet opens full-screen... until I use the spin control. Then I am no longer able to manually enter data and can only use the spin controls. One of the frustrating issues is that when the screen locks up, it affects all data entry cells on the current worksheet... not just the one associated with the spin button. And not all of the data entry cells have spin buttons. So it affects the design of the entire page... and potentially force me to add spin buttons to all the data input cells.

Another interesting issue... I have a series on calculators on separate tabs all in one workbook. And the problem occurs separately on each one. In other words, the workbook doesn't lock up. Each individual tab does after interacting with a spin button on that specific sheet.

 

[Speedy]

Hi,

And show: DisplayFormulaBar = True
Following example tested with Excel 2013 32 Bit Windows 8.1