Disable Page Break Preview Button
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 |
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 |
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com