worksheet image appears when workbook open

[nancyo]

I have a workbook that I have been editing all day. It contains a macro for automatic footers when opened, with the screenupdating turned off. I have been working on this workbook for a while, and have closed and opened many times without any problems for WEEKS!.

I recently saved the same workbook with a different name to check some new formulas, and when the new file opened, there was an "image" of part of a worksheet behind my message box ("automatic footers in progress...") when the screen is normally white.

I went back and re-opened the original workbook and now there is an image there as well, but a different one! I exited excel without saving, went for a walk, breathed, and then re-opend the both files and the images are still there!!!

This totally wrecks the workbook...anyone have any ideas? I will have to start all over which means I wasted all day, and have to refigure out a bunch of stuff!!!


[ This Message was edited by: nancyo on 2002-05-14 12:50 ]

[Jack in the UK]

can i ask what is the picture off, or best you dont say, in which case PM me to explain, you will know my name so you know your safe telling me, pm me please if this is the case.

also where is this image is it colour and what file type,

where exactly is it located, in sheet or in head/footer

[nancyo]

The "image" is a section of a worksheet, and appears in the background behind the message box as the automatic footers' macro runs.

I went into the file and added a blank worksheets, left the file on the blank sheet, saved, and re-opened, and it was fine.

I should not have had to do this...any suggestions are welcome.

[Jack in the UK]

[quote]
On 2002-05-14 13:35, nancyo wrote:
The "image" is a section of a worksheet, and appears in the background behind the message box as the automatic footers' macro runs.

I went into the file and added a blank worksheets, left the file on the blank sheet, saved, and re-opened, and it was fine.

I should not have had to do this...any suggestions are welcome.


OK you have a picture thats not welcome in the userform that appered by alien means
suggers remove the link in vba or should i say VBE

do you know how to do this?

[Jack in the UK]

Open the VBE and select the selector for the user form concerned.

View properties window
Select categories tab
Scroll down to picture
Click the + sign
See the drop down will have this alien picture
Click on the fie name a drop down should appear
Edit the feel of the file location to read NONE

Then re run the sheet

Has it gone..

[nancyo]

Jack - I printed this out. I will try this in the AM when I get to work, and see if there is a problem. If not, I need to wait until the problem happens again, and will try.

I'll let you know. THANKS!!!

[Jack in the UK]

Please keep on this feed so you have a chain others can follow rather than a second floating about, not the feed for later

feel this should work OK

good luck


Marker Image User Form

[CompTutor]

Nancyo,
While the hi-tech solution may be the answer, I had a similar problem a while back and it turned out to be my RAM overflowing. I cold booted (simple solution for simple person, huh?) and it cured itself...
Good luck--let us know what works?

[Jack in the UK]

Very true Microsoft always say @ have you re booted @ to the smallest and biggest problem, they teach us and encourage us this, I recommend cold boot though as lower version of windows suffers mirror memory and dirty data addressing in memory allocations

But as I often sat I feel the question, the guy did say he had @wasted his whole day@, I took assumption he was now at home so pointless to ask him to do this as I knew or thought it would self take care of this bit for me next morning…., so I advised the correct VBE method, this is not techi I feel – just utilization of the software application package..

Thank you I have learn quickly to ask, a few ground questions, again thanks

[nancyo]

OK - stupid questions of the day (at least the morning):

1. Jack - I tried to follow what you suggested, checked the properties windows of several of the worksheets under VBA. Did not see anything listed as picture?

2. OK - the really stupid question of the day - what is a cold boot? Does this show my ignorance? Obviously, I am not a computer person...

The image that appears is different each time when I open the files. This AM, the first file opened fine, I closed it and reopened it and an image was there...