sebbutin
Fri Sep 01 06:08:10 CDT 2006
I have implemented the procedure indicated on your link. The main issue
is that, when you capture the screen and paste it on a new spreadsheet,
you also paste the Excel background and not the userform itself.
I have also tried your solution but I do not get the same final result
as the new label still disappears when the useform is printed!!
Nevertheless, your hint was helpful as I eventually used lables but on
a different way: I cancelled the caption of each frame, reduced its
heighth and placed a label on top of it. The lable, of course, has the
same background color as the rest of the frame. I do have a straight
white line under it but it is acceptable.
This would work on a userform with few frames but would definitely
become a nightmare with multiple frames!
Thank you for your help!
Sebastien
Jean-Guy Marcil wrote:
> sebbutin was telling us:
> sebbutin nous racontait que :
>
> > Bonjour,
> >
> > l'instruction est toute simple: userform.printform
> >
> > A partir de l=E0, mon imprimante m'imprime bien tous les =E9l=E9ments de
> > mon userform SAUF le titre des frames pour je ne sais quelle raison
> > alors que ces derniers sont bien visibles sur l'=E9cran...
> > Une id=E9e?
>
> Since this is normally an English speaking group, I will reply in English=
so
> everyone can participate in the discussion.
>
> This is an undocumented bug (At least, I have not found anything about th=
is
> in MSDN), lucky you!
>
> See the following discussion from an Excel groups. You will need to adapt
> the code to Word to use the workaround.
>
http://tinyurl.com/lrt5p
>
> Personally, the workaround I have found is to simply place a label control
> with the frame caption text exactly over the frame caption. As soon as you
> place it over the frame, it disappears from the Userform (hidden by the
> frame and you cannot place it "over/in front of" the frame.
> However, when you use PrintForm, it will print... at least, it does for m=
e=2E
> Go figure!
>
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site:
http://www.word.mvps.org