After running AddIn, application needs to be re-drawn

[Michelle]

After running code from an add-in that I've made: If I have used a hyperlink
from a form, the screen needs to be 're-drawn' i.e. the selected area
doesn't appear selected until I scroll up and down so that the range area
goes off and comes back on screen. It doesn't even appear selected if you
minimise the application and bring it back, only scrolling or carrying out
an action - like making something italic or something, will make the
selected area appear selected.

I've tried application.screenupdating = true, and AppActivate to no avail -
any ideas?

Thanks

Michelle

 

[Jim Rech]

I didn't follow all of your post but if you want to try programmatically
scrolling the window you could do this:

ActiveWindow.LargeScroll 1
ActiveWindow.LargeScroll -1

You probably will want to have screen updating on when you run this. I have
no other ideas if this doesn't help.

--
Jim
| After running code from an add-in that I've made: If I have used a
hyperlink
| from a form, the screen needs to be 're-drawn' i.e. the selected area
| doesn't appear selected until I scroll up and down so that the range area
| goes off and comes back on screen. It doesn't even appear selected if you
| minimise the application and bring it back, only scrolling or carrying out
| an action - like making something italic or something, will make the
| selected area appear selected.
|
| I've tried application.screenupdating = true, and AppActivate to no
avail -
| any ideas?
|
| Thanks
|
| Michelle
|