J
JR
In XP, office XP I can not recreate behavior I had going
in office 2000 where I used "Application.WindowState =
xlMinimized" to hide the application while a userform
remained visable and allowed a very specific save sub to
run "invisably" (both the original workbook and the copyto
workbook were minimized so the user would not be
distracted by the copy-paste action being visable -- I
only save cells that collect user input vs. the whole
wookbook with all formulae, etc.)
Any Ideas on how to leave the userform visable while
minimizing the workbooks?
Thanks
JR
in office 2000 where I used "Application.WindowState =
xlMinimized" to hide the application while a userform
remained visable and allowed a very specific save sub to
run "invisably" (both the original workbook and the copyto
workbook were minimized so the user would not be
distracted by the copy-paste action being visable -- I
only save cells that collect user input vs. the whole
wookbook with all formulae, etc.)
Any Ideas on how to leave the userform visable while
minimizing the workbooks?
Thanks
JR