Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Objects to PrintDialog
Is there a way to add checkboxes, dropdown ect. to the printdialog, like
when i'm adding objects to a userform using code ? I need to precent some reporttype-choises to the user when the print button is pressed. Hoping for a positive answer Claus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Objects to PrintDialog
Claus,
Using the PrintDialog API and hook/templates you can achieve it, but not natively in VBA, AFAIK. Easier would be to make your own userform with the options, then make those changes to the WB and print it yourself. NickHK "Claus" wrote in message ... Is there a way to add checkboxes, dropdown ect. to the printdialog, like when i'm adding objects to a userform using code ? I need to precent some reporttype-choises to the user when the print button is pressed. Hoping for a positive answer Claus |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Objects to PrintDialog
Nick,
I'm not a pro, though i did VBA on and off for some years. Whats the PrintDialog API ? If i'm to build a userform, how do i get the list of printers, printerstatus, location and so on ? Claus "NickHK" skrev i en meddelelse ... Claus, Using the PrintDialog API and hook/templates you can achieve it, but not natively in VBA, AFAIK. Easier would be to make your own userform with the options, then make those changes to the WB and print it yourself. NickHK "Claus" wrote in message ... Is there a way to add checkboxes, dropdown ect. to the printdialog, like when i'm adding objects to a userform using code ? I need to precent some reporttype-choises to the user when the print button is pressed. Hoping for a positive answer Claus |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Objects to PrintDialog
Claus,
Found this: http://pubs.logicalexpressions.com/P...cle.asp?ID=183 NickHK "Claus" wrote in message ... Nick, I'm not a pro, though i did VBA on and off for some years. Whats the PrintDialog API ? If i'm to build a userform, how do i get the list of printers, printerstatus, location and so on ? Claus "NickHK" skrev i en meddelelse ... Claus, Using the PrintDialog API and hook/templates you can achieve it, but not natively in VBA, AFAIK. Easier would be to make your own userform with the options, then make those changes to the WB and print it yourself. NickHK "Claus" wrote in message ... Is there a way to add checkboxes, dropdown ect. to the printdialog, like when i'm adding objects to a userform using code ? I need to precent some reporttype-choises to the user when the print button is pressed. Hoping for a positive answer Claus |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Objects to PrintDialog
Thank you Nick
I'll dig into it Claus "NickHK" skrev i en meddelelse ... Claus, Found this: http://pubs.logicalexpressions.com/P...cle.asp?ID=183 NickHK "Claus" wrote in message ... Nick, I'm not a pro, though i did VBA on and off for some years. Whats the PrintDialog API ? If i'm to build a userform, how do i get the list of printers, printerstatus, location and so on ? Claus "NickHK" skrev i en meddelelse ... Claus, Using the PrintDialog API and hook/templates you can achieve it, but not natively in VBA, AFAIK. Easier would be to make your own userform with the options, then make those changes to the WB and print it yourself. NickHK "Claus" wrote in message ... Is there a way to add checkboxes, dropdown ect. to the printdialog, like when i'm adding objects to a userform using code ? I need to precent some reporttype-choises to the user when the print button is pressed. Hoping for a positive answer Claus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding pictures, images or objects | Excel Discussion (Misc queries) | |||
Adding specific objects based on data... | Excel Discussion (Misc queries) | |||
Adding Embedded OLE Objects on a Spread Sheet | Excel Programming | |||
Adding OLE objects from VBA in Excel | Excel Programming | |||
Screen is flashing when VBA adding objects into Excel sheet? | Excel Programming |