One tab cells 'ghosting' or 'bleeding' through to another tab - no data, just a pic of a cell section

jfarc

Active Member
Joined
Mar 30, 2007
Messages
308
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.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,123,346
Messages
5,601,079
Members
414,426
Latest member
fraru

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top