excel - Visual bug when displayheadings = false -
as title says, experience visual bugs when , when
activewindow.displayheadings = false
here image of type of bug receive (the masterfully blued-out info due confidential work information, don't mind it). happens when scroll left-right:
after refreshing (no bug):
note there black stripe , cell on right, merged cell looks sort of cut in half? looks others normally.
selecting makes bug disappear in selected region. such, have developped little macro refresh screen. selects whole screen - erasing bugs - , returns selected range. works fine.
application.screenupdating = false dim active range set active = activecell cells.select active.select application.screenupdating = true
now, 1 of 2 things, preferrably first:
1) figure out why happens, if happens me, , how fix it.
2) think of way launch refresh macro every time user scrolls side side.
additional info:
excel 2010
happens whether application.enableevents, screenupdating, etc true or not.
Comments
Post a Comment