Expand options not showing up

[The Phil]

Hi,

This is tough to explain, but here goes.

This link isn't to a post of mine, but figure 4 shows what kind of expand/collapse menu I'm talking about: http://www.itechtalk.com/thread10194.html

I'm using a macro that pulls information into a collapsable report.

The problem I have is that when I run the macro to update this report, the expand/collapse buttons next to the row numbers aren't there. The row numbers are butt up against the left of the screen.

It seems to be a display glitch because if I scroll down, the rows that were off screen are moved over to make room for the buttons, then when I scroll back up it refreshes that as well so that the expance collapse column is there.

Is there any kind of code I could put at the end of my VB script that would refresh the display?

If this isn't clear please let me know.

[AlphaFrog]

This should force a screen refresh. Don't know if it cures your problem though.

Please Login or Register  to view this content.

[The Phil]

Hi alphafrog,

Unfortunately this problem persists on multiple sheets. I looped your code through all the sheets but it didn't work.

I ended up trying to use the application.goto command and have it go to each sheet just before the macro ends and that ended up solving the problem.