Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print UserForm A4 size
I have a userForm that is A4 in size and I have tried to use the code
below to print the Active window as my userForm is the 'Active Window' However the print outcome is 'PRINT SCREEN' with the bottom one third of my userform not printing at all. In a Button_Click event I have:- DoEvents 'Copy the Activewindow to the Clipboard keybd_event VK_MENU, 0, 0, 0 keybd_event VK_SNAPSHOT, 0, 0, 0 keybd_event VK_SNAPSHOT, 0, KEYEVENTF_KEYUP, 0 keybd_event VK_MENU, 0, KEYEVENTF_KEYUP, 0 DoEvents 'Copy the Clipboard to the Worksheet Range(A1").select ActiveSheet.Paste DoEvents Any help TIA. SZ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am trying to print on legal size paper, i cant set size. | Excel Discussion (Misc queries) | |||
Save as PDF not same size as Print and Print Preview in Excel | Excel Discussion (Misc queries) | |||
Zoom size doesn't equal print size | Excel Discussion (Misc queries) | |||
print view & print, in excel, different size cells | Excel Discussion (Misc queries) | |||
Print UserForm A4 size | Excel Programming |