View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default After running AddIn, application needs to be re-drawn

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
"Michelle" wrote in message
...
| 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
|