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.
ps, i have tried application.screenupdating, fyi
I'm not following the problem.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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?
post the workbook. I can't understand how this is happening.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
