Excel background refresh distortion

[ratman]

Hello....I have an Excel worksheet with an intense backgroud gif file formating from A1 through M30.&nbsp;&nbsp;On this worksheet (not a user form) I have commandbuttons(no macro's attached to the command buttons)with hyperlinks to other Excel workbooks and everything is fine except when I return to the main formentioned worksheet with the hyperlinks the video/backgroud appears distorted......I mean the thing looks like it's contrast is max'd out or something. The worksheet loads fine but when I link to and then back the backgroud gif is messed. I've tried it on 3 systems with the same results.<br><br>In HIS Grip,<br>Dave Rattigan

 

[MasterRacker]

You need to recreate the GIF file with the Windoiws standard palette.&nbsp;&nbsp;Many graphics programs will create files with &quot;optimized&quot; palettes so they look better.&nbsp;&nbsp;However If you are displaying one of these and you switch to another window, Windows will switch palettes to the Windows standard, sometimes staying with that palette when you move back to the window thatis displaying the picture.&nbsp;&nbsp;&nbsp;Your safest bet is to ensure that all graphics you create are using the standard palette. <p> Jeff<br><a href=mailto: masterracker@hotmail.com> masterracker@hotmail.com</a><br><a href= > </a><br> Of all the things I've lost in life, I miss my mind the most ...

 

[Dreamboat]

Nice info, masterracker. Thanks. <p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>

 

[ratman]

I have many .xls files in same directory.&nbsp;&nbsp;Each filename is named mmddyy.xls&nbsp;&nbsp;&nbsp;&nbsp;<br>example<br>c:\My Excel File\Production Files\0705.00.xls<br>or as referenced in the macro<br>C:\My Excel Files\Production Files\&quot; & myFile<br><br>I now have an InputBox that auto_opens and user requests to readonly one of the files by entering <br>mmddyy&nbsp;&nbsp;&nbsp;<br>for example:&nbsp;&nbsp;070500<br><br>Sub button0_onclick()<br>&nbsp;&nbsp;Dim returntext<br><br>&nbsp;&nbsp;&nbsp;returntext = InputBox(&quot;Enter the month day year with NO SPACES.....example: you type&nbsp;&nbsp;&nbsp;080400&nbsp;&nbsp;&nbsp;to view the file for 8/4/00&quot<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myFile = Format(thisdate, &quot;mm&quot & Format(thisdate, &quot;dd&quot & Format(thisdate, &quot;yy&quot & returntext & &quot;.xls&quot;<br><br>Workbooks.Open Filename:=&quot;C:\My Excel Files\Production Files\&quot; & myFile<br><br><br>as long as the file exists it opens <br>I now need to validate or error control the inputbox with an error message &quot;date format incorrect or file not found&quot;&nbsp;&nbsp;<br>to loop until inputboxtext = true or application.quit<br><br>also need to have inputbox open again after activeworkbook minimized or closed.<br>