Display Error

[wetz]

Hi Everyone!
I have built a pretty in depth spreadsheet for me to use as a calculator at work. I have lots of information to put into the system in order to be able to use the calculator. All the calculations work, but I am having an issue with the way the spreadsheet displays when i put information in. It is probably easier to show you than to explain, but I will try. So I have everything hidden at first except for the main page "Dashboard" seen below:
Dashboard.PNG
In order to go into the data entry pages, you click the buttons within this sheet. For example, I will go into the income sheet by clicking the "Borrower Income" button and get this page:
Income.PNG
Once I start inputting data, the page goes funny and starts overlaying images from the "Dashboard" onto the "Borrower Income" page, making it hard to work on what I am working on. The image below shows what I am talking about. Yellow highlights are added by me to mark the areas popping up.
Income Page.PNG
I have noticed that if I turn Calculations to "Manual", then the issue goes away, but that means I have to remember to continually hit the calculate now button and that is just annoying. Does anyone have any ideas to remedy the situation???



File details:
Excel 2013
macro enabled workbook


Thanks in advance for your help!!

[Kevin#]

One way to deal this would be to set recalc to manual and create a change event whenever anything changes in any of the cells in that worksheet(s) and force a recalculation.

Put the code into the relevant worksheet module(s)

Please Login or Register  to view this content.