Excel user form print out and change multi pages back colour

[Apple08]

Hi everyone

I am using Excel 2013. Please is it able to change the multi pages in different back colour?

Also I have several long user forms and how can I have the full content print out without the scroll bar? When I print out the long user form, it only prints out the screen content and also includes the scroll bar which I don’t want.

Any help is appreciated!

 

[Apple08]

Please see my print to printer code below:

Private Sub CommandButton1_Click()
Dim RetStat
RetStat = Application.Dialogs(xlDialogPrinterSetup).Show
If RetStat Then Me.PrintForm
End Sub