Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of pages
Hello,
I need to find out how many pages does a sheet contain (can be 1 or 2 pages only), before sending the following line: sheet.PrintPreview, ex PageNum = sheet.Number_Of_Pages_To_Be_Printed if PageNum = 1 then sheet.PrintPreview else alert user end if This will print a 1 page list, if the number of items exceeds the 1st page, the printing has to be cancelled Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of pages
Hi fernando
'Place in "ThisWorkbook" module Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True HowManyPages End Sub 'Place in a "General" module Sub HowManyPages() Dim Cmd As String Cmd = "GET.DOCUMENT(50,""" & ActiveSheet.Name & """)" If Application.ExecuteExcel4Macro(Cmd) = 1 Then Application.EnableEvents = False ActiveSheet.PrintPreview Application.EnableEvents = True Else MsgBox "Too many sheets" End If End Sub -- XL2002 Regards William "fernando" wrote in message ... | Hello, | | I need to find out how many pages does a sheet contain | (can be 1 or 2 pages only), before sending the following | line: sheet.PrintPreview, ex | | PageNum = sheet.Number_Of_Pages_To_Be_Printed | if PageNum = 1 then | sheet.PrintPreview | else | alert user | end if | | This will print a 1 page list, if the number of items | exceeds the 1st page, the printing has to be cancelled | | Thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of pages
Try this:
If you want to make sure that each and every time you print, only 1 page is used, go to: File | Page setup. In the "Page" tab, choose to scale to 1 page in width and remove the 1 in the height box. Pierre "fernando" a écrit dans le message de ... Hello, I need to find out how many pages does a sheet contain (can be 1 or 2 pages only), before sending the following line: sheet.PrintPreview, ex PageNum = sheet.Number_Of_Pages_To_Be_Printed if PageNum = 1 then sheet.PrintPreview else alert user end if This will print a 1 page list, if the number of items exceeds the 1st page, the printing has to be cancelled Thanks in advance! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of pages
Thanks
-----Original Message----- Hi fernando 'Place in "ThisWorkbook" module Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True HowManyPages End Sub 'Place in a "General" module Sub HowManyPages() Dim Cmd As String Cmd = "GET.DOCUMENT(50,""" & ActiveSheet.Name & """)" If Application.ExecuteExcel4Macro(Cmd) = 1 Then Application.EnableEvents = False ActiveSheet.PrintPreview Application.EnableEvents = True Else MsgBox "Too many sheets" End If End Sub -- XL2002 Regards William "fernando" wrote in message ... | Hello, | | I need to find out how many pages does a sheet contain | (can be 1 or 2 pages only), before sending the following | line: sheet.PrintPreview, ex | | PageNum = sheet.Number_Of_Pages_To_Be_Printed | if PageNum = 1 then | sheet.PrintPreview | else | alert user | end if | | This will print a 1 page list, if the number of items | exceeds the 1st page, the printing has to be cancelled | | Thanks in advance! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
Auto Number Several Pages | Excel Discussion (Misc queries) | |||
How can I number pages so it changes every 3 pages? | Excel Discussion (Misc queries) | |||
Number of pages | Excel Worksheet Functions | |||
How do i number pages in a header consequently | Excel Worksheet Functions |