#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Ghost image

Hi Group,

Doing a macro with a chart. Creates the chart just fine,
but then I try and do formating and moving it. It moves
ok, but then there is a ghost image left on the screen
and the rest of the formating is not done. I have tried
turning ScreenUpdate = True, tried even selecting the
worksheet and then going back to the chart, which made
the ghost image go away, but I could still not finish the
formating. If i run the formating portion of the code by
itself, it seems to do ok, but I am unable to incorporate
it into the code. Any ideas?

Thanks guys and gals.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Ghost image

When's the last time you emptied your TEMP folder?
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
"David" wrote in message
...
Hi Group,

Doing a macro with a chart. Creates the chart just fine,
but then I try and do formating and moving it. It moves
ok, but then there is a ghost image left on the screen
and the rest of the formating is not done. I have tried
turning ScreenUpdate = True, tried even selecting the
worksheet and then going back to the chart, which made
the ghost image go away, but I could still not finish the
formating. If i run the formating portion of the code by
itself, it seems to do ok, but I am unable to incorporate
it into the code. Any ideas?

Thanks guys and gals.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Ghost image

Just ried it, of no avail. Temp was pretty clean before.
If I step through it and manually select the chart, it
seems to work, but I don't seen to be able to give it
focus with the code. I can get the ghost to leave, but I
still can not get the formats to take affect.
Thanks Dreamboat

-----Original Message-----
When's the last time you emptied your TEMP folder?
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
"David" wrote in

message
...
Hi Group,

Doing a macro with a chart. Creates the chart just

fine,
but then I try and do formating and moving it. It moves
ok, but then there is a ghost image left on the screen
and the rest of the formating is not done. I have tried
turning ScreenUpdate = True, tried even selecting the
worksheet and then going back to the chart, which made
the ghost image go away, but I could still not finish

the
formating. If i run the formating portion of the code

by
itself, it seems to do ok, but I am unable to

incorporate
it into the code. Any ideas?

Thanks guys and gals.



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
ghost macro gevans Excel Worksheet Functions 4 March 8th 06 04:40 PM
Hyperlink to an image in other worksheet, displaying entire image. twilliams Excel Worksheet Functions 0 February 7th 06 10:02 PM
Ghost Links [email protected] Links and Linking in Excel 3 August 20th 05 04:02 PM
Export the worksheet background image as an image file - possible? DataFreakFromUtah Excel Programming 2 April 10th 04 04:49 PM
Open image from web in window same size as image? Milos Setek Excel Programming 0 February 5th 04 03:33 AM


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"