Disable Page Break Preview Button

[John Salig]

I have an application where I am using Excel in the background to print a
spreadsheet. My application has a print preview - where I use Excel's Print
Preview feature. This worked fine in Excel 2000 - however, I am now running
into an issue with Excel XP. When displaying the Print Preview, there is
now a new button called "Page Break Preview". I would like to find out if
there is a way to programmatically remove or disable this button. This
button takes the user back to the spreadsheet which I do not want to happen
(since the user was not viewing the spreadsheet to begin with).

Any help is appreciated.

John

 

[Mike]

-----Original Message-----
I have an application where I am using Excel in the background to print a
spreadsheet. My application has a print preview - where I use Excel's Print
Preview feature. This worked fine in Excel 2000 - however, I am now running
into an issue with Excel XP. When displaying the Print Preview, there is
now a new button called "Page Break Preview". I would like to find out if
there is a way to programmatically remove or disable this button. This
button takes the user back to the spreadsheet which I do not want to happen
(since the user was not viewing the spreadsheet to begin with).

Any help is appreciated.

John


.

One way would be to find the window handle of the button
using Windows API's and disable and/or hide this button,
again using API calls. Look in MSDN for window handle
enumeration functions. Search for "Enumerate Windows"

Mike