Caption of a frame

[sebbutin]

I am desperately trying to find a way how to print the captions of my
userform's frames. Right now, these captions do appear on the userform
but do not when I print it.

Thanks for your hints on this matter.

Sebastien

 

[Jean-Guy Marcil]

sebbutin was telling us:
sebbutin nous racontait que :

I am desperately trying to find a way how to print the captions of my
userform's frames. Right now, these captions do appear on the userform
but do not when I print it.

Thanks for your hints on this matter.

Sebastien

How are you printing the userform?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[sebbutin]

Bonjour,

l'instruction est toute simple: userform.printform

A partir de là, mon imprimante m'imprime bien tous les éléments de
mon userform SAUF le titre des frames pour je ne sais quelle raison
alors que ces derniers sont bien visibles sur l'écran...
Une idée?

Merci,

Sébastien

 

[Jean-Guy Marcil]

sebbutin was telling us:
sebbutin nous racontait que :

Bonjour,

l'instruction est toute simple: userform.printform

A partir de là, mon imprimante m'imprime bien tous les éléments de
mon userform SAUF le titre des frames pour je ne sais quelle raison
alors que ces derniers sont bien visibles sur l'écran...
Une idée?

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 this
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 me.
Go figure!

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[sebbutin]

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