Possible to Change DialogPrintPreview CBs?
 

My application is for Excel98 and newer. I use
Application.Dialogs(xlDialogPrintPreview).Show so users can preview the
reports. However, by default, the user can change my header and footer if
desired. Is it possible to disable the Header and Footer CBs when calling
xlDialogPrintPreview?

Thank you in advance.
Jim Kobzeff

Possible to Change DialogPrintPreview CBs?
 

The only adjusment you can make the I am aware of its to call it like this:

Application.Dialogs(xlDialogPrintPreview).Show False

does that do what you want?

--
Regards,
Tom Ogilvy

"JK" wrote in message news:ErCsf.5687$Ff6.1030@trnddc01...
My application is for Excel98 and newer. I use
Application.Dialogs(xlDialogPrintPreview).Show so users can preview the
reports. However, by default, the user can change my header and footer if
desired. Is it possible to disable the Header and Footer CBs when calling
xlDialogPrintPreview?

Thank you in advance.
Jim Kobzeff

Possible to Change DialogPrintPreview CBs?
 

It should did, Tom. Thank you.


"Tom Ogilvy" wrote in message
...
The only adjusment you can make the I am aware of its to call it like
this:

Application.Dialogs(xlDialogPrintPreview).Show False

does that do what you want?

--
Regards,
Tom Ogilvy

"JK" wrote in message news:ErCsf.5687$Ff6.1030@trnddc01...
My application is for Excel98 and newer. I use
Application.Dialogs(xlDialogPrintPreview).Show so users can preview the
reports. However, by default, the user can change my header and footer if
desired. Is it possible to disable the Header and Footer CBs when calling
xlDialogPrintPreview?

Thank you in advance.
Jim Kobzeff