| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel graphs change when pasted into Publisher - Metafiles change? | Charts and Charting in Excel | |||
| change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Linear Mode
