PDA

View Full Version : parent window refresh



drawworkhome
01-31-2010, 09:38 AM
hi all, is there a way to refresh the parent window?
what i have going on is when excel fires up, i hide the app and just display a form. they click a button and a spread sheet pops up. when that happens, the named range name box (just that area) shows the previous form and not the familiar white color of the name box. is there a way to refresh this?
thank you.

drawworkhome
01-31-2010, 09:45 AM
ps, i have tried application.screenupdating, fyi

lucas
01-31-2010, 09:56 AM
I'm not following the problem.

drawworkhome
01-31-2010, 10:22 AM
instead of showing the value in the name box, ie, a1, or "some named range" it displays the remnant of the picture of the form. in this case, my form has a picture as a background of trees. it is showing the trees in the name box instead of a1 or whatever. does that help?

lucas
01-31-2010, 10:34 AM
post the workbook. I can't understand how this is happening.