I have a large workbook that contains macros and many tabs. The workbook is in the .xls format. This problem happens when running on different PC's running Win7 or Win10, Excel2016 or Office365. I've read many posts on this and other forums and this is not a problem that has anything to do with having multiple tabs selected at the same time.
When I'm in [Sheet3] and hit a button I've set up to take the user to [Sheet1], then when there in [Sheet1] the user will perform various data entry functions (enter data in a cell and hit <tab> or <enter> or may also hit the <delete> key to delete data already in the current cell, etc.) a picture of only a section of cells from [Sheet3] will appear on the currently viewed tab [Sheet1]. No actual data is being transferred from one tab to another, it is simply a screen shot of a section of cells from [Sheet3].
Usually this screen shot from [Sheet3] only flashes for a split second on the current view of [Sheet1], yet other times this screen shot will stay, thus blocking the view of some of the cells on [Sheet1]. It won't prevent me from keying in data into the actual cells in [Sheet1], you just can't see these cells because they are being blocked by this phantom screen shot.
Although, if I simply <pgDn> then <PgUp>, the screen shot picture of the other tab disappears. Very strange.
When I'm in [Sheet3] and hit a button I've set up to take the user to [Sheet1], then when there in [Sheet1] the user will perform various data entry functions (enter data in a cell and hit <tab> or <enter> or may also hit the <delete> key to delete data already in the current cell, etc.) a picture of only a section of cells from [Sheet3] will appear on the currently viewed tab [Sheet1]. No actual data is being transferred from one tab to another, it is simply a screen shot of a section of cells from [Sheet3].
Usually this screen shot from [Sheet3] only flashes for a split second on the current view of [Sheet1], yet other times this screen shot will stay, thus blocking the view of some of the cells on [Sheet1]. It won't prevent me from keying in data into the actual cells in [Sheet1], you just can't see these cells because they are being blocked by this phantom screen shot.
Although, if I simply <pgDn> then <PgUp>, the screen shot picture of the other tab disappears. Very strange.