f150man
07-12-2001, 06:53 AM
Morning good people,
I'm really stuck on this problem... Does anyone know how to preset the option in Excels Print dialogbox (using VB) at design time. I need to limit the users options for the 'Print What' section, and for the 'Print Range' section depending on the value of certain variables.
I know you can use the .show method and set the particular arguments to meet your needs, but it doesn't seem to be working for some parts (eg arg7 for xlDialogPrint - print_what).
Does anyone out there in codeland know how to do this...Or even know if it is possible???
Thanks
F150man
I'm really stuck on this problem... Does anyone know how to preset the option in Excels Print dialogbox (using VB) at design time. I need to limit the users options for the 'Print What' section, and for the 'Print Range' section depending on the value of certain variables.
I know you can use the .show method and set the particular arguments to meet your needs, but it doesn't seem to be working for some parts (eg arg7 for xlDialogPrint - print_what).
Does anyone out there in codeland know how to do this...Or even know if it is possible???
Thanks
F150man