Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ghost macro | Excel Worksheet Functions | |||
Hyperlink to an image in other worksheet, displaying entire image. | Excel Worksheet Functions | |||
Ghost Links | Links and Linking in Excel | |||
Export the worksheet background image as an image file - possible? | Excel Programming | |||
Open image from web in window same size as image? | Excel Programming |