PC Review


Reply
Thread Tools Rate Thread

After running AddIn, application needs to be re-drawn

 
 
Michelle
Guest
Posts: n/a
 
      18th Nov 2008
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

 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      18th Nov 2008
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" <(E-Mail Removed)> wrote in message
news:ACE85244-B8ED-4E35-B1D2-(E-Mail Removed)...
| 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
|

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to detect if an addin is running Gee Weez Microsoft Excel Programming 1 8th Feb 2010 11:42 PM
After Running AddIn - continued Michelle Microsoft Excel Programming 0 18th Nov 2008 12:16 PM
addin not running correctly =?Utf-8?B?c2M=?= Microsoft Excel Programming 0 10th Jul 2006 02:54 PM
addin not running correctly =?Utf-8?B?c2M=?= Microsoft Excel Programming 1 7th Jul 2006 11:50 PM
COM-Addin Problem when outlook is not running =?Utf-8?B?SmVmZg==?= Microsoft Outlook VBA Programming 0 4th Mar 2004 12:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:24 AM.