Possible to Change DialogPrintPreview CBs?

J

JK

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
 
T

Tom Ogilvy

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?
 
J

JK

It should did, Tom. Thank you.


Tom Ogilvy said:
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Footer Page Number Question 1
Can we disable Excel's default toolbar? 4
Create Word (or Excel) Reports via VBA 1
Create header/footer txt file and link to Excel worksheets 1
Is there a better way to protect our password? 1
Is There a Function To Reset Macros? 4
Please Help if You Can 3
Issues with Hyperlinks in XL97 2

Top