I have a "working" userform within a spreadsheet for order-entry. However, I
would like to display a "non-working" userform on another worksheet that
gives instructions on how to actually execute and run the order-entry macros.

Do I have to create a new, identical userform or is there a way to display
it on the other worksheet? It would be great if there was a way to have it
display permanently, or like a watermark.

Thanks for your help.

Les

You can do a print screen and paste it into another sheet. Bring up your
form on the screen so that it has the focus, then press Alt+PrtScrn > go to
the blank sheet and right click, then click paste. It should paste only the
UserForm. Then you can use the drawing tool bar to make arrows, etc. and
type in text boxes for the instructions. Rots o ruck.

"WLMPilot" wrote:

> I have a "working" userform within a spreadsheet for order-entry. However, I
> would like to display a "non-working" userform on another worksheet that
> gives instructions on how to actually execute and run the order-entry macros.
>
> Do I have to create a new, identical userform or is there a way to display
> it on the other worksheet? It would be great if there was a way to have it
> display permanently, or like a watermark.
>
> Thanks for your help.
>
> Les