Excel 2016 MSO (16.0.4639.1000) 32-bit
This is a macro enabled workbook with several modules in Visual Basic. Also, every spreadsheet has Worksheet_BeforeDoubleClick sub routines. One spreadsheet is "Summary Report". "Summary Report reads values (via if statements and simple = formulas) on the other spreadsheets. There are a total of 17 spreadsheets in the single workbook. Every spreadsheet is password protected with certain cells unlocked for user input.
My problem is that on occasion, and I have not yet been able to predict or cause it to happen, I will be editing, in unprotected mode, a spreadsheet and a portion of the "Summary Report" spreadsheet will overlay part of my current spreadsheet. It disappears if I scroll it off, then scroll back. It also disappears if I change the zoom level. I edit a cell, go to another, an it happens again. It has not happened when the spreadsheet is protected, and it does not happen all the time. Taking a foam rubber bat to the computer has not helped, but has calmed me somewhat.
Any experience with this? Or any ideas where to look for the source of the problem?
Thanks all.
Larry
This is a macro enabled workbook with several modules in Visual Basic. Also, every spreadsheet has Worksheet_BeforeDoubleClick sub routines. One spreadsheet is "Summary Report". "Summary Report reads values (via if statements and simple = formulas) on the other spreadsheets. There are a total of 17 spreadsheets in the single workbook. Every spreadsheet is password protected with certain cells unlocked for user input.
My problem is that on occasion, and I have not yet been able to predict or cause it to happen, I will be editing, in unprotected mode, a spreadsheet and a portion of the "Summary Report" spreadsheet will overlay part of my current spreadsheet. It disappears if I scroll it off, then scroll back. It also disappears if I change the zoom level. I edit a cell, go to another, an it happens again. It has not happened when the spreadsheet is protected, and it does not happen all the time. Taking a foam rubber bat to the computer has not helped, but has calmed me somewhat.
Any experience with this? Or any ideas where to look for the source of the problem?
Thanks all.
Larry
