Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a spreadsheet that is run entirely from a userform. I
want the option to print out the userform. I currently use the following code to perform this. Private Declare Function OpenClipboard& Lib "user32" (ByVal hwnd&) Private Declare Function EmptyClipboard& Lib "user32" () Private Declare Function CloseClipboard& Lib "user32" () Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte _ , ByVal bScan As Byte, ByVal dwFlags&, ByVal dwExtraInfo&) Private Sub PrintButton_Click() Me.Repaint OpenClipboard 0& EmptyClipboard keybd_event &H2C, 0, 0&, 0& CloseClipboard DoEvents Application.ScreenUpdating = False Dim NewBook As String Workbooks.Add: ActiveSheet.Paste NewBook = ActiveWorkbook.Name With ActiveSheet.PageSetup .RightFooter = Me.Caption & " Le &D Page &P/&N" .PrintGridlines = False .Orientation = xlLandscape .PaperSize = xlPaperA4 .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = False End With ActiveWindow.Visible = False Application.ScreenUpdating = True Me.Hide Windows(NewBook).SelectedSheets.PrintOut Copies:=1 Workbooks(NewBook).Close False Me.Show End Sub this works well, with a couple exceptions. I would like to be able to print the form without the background. and I would like to maximize the form, so it prints as large as possible on the paper. Is this possible and if so, how would I go about doing this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing - Setup | Setting up and Configuration of Excel | |||
Page Setup Printing | Excel Discussion (Misc queries) | |||
Setup Spell Checking on Userform textboxes | Excel Programming | |||
Setup Userform | Excel Programming | |||
Setup Userform | Excel Programming |