View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike[_68_] Mike[_68_] is offline
external usenet poster
 
Posts: 1
Default Disable Page Break Preview Button


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