Praedico
New Member
- Joined
- Jul 17, 2008
- Messages
- 43
Greetings Excelphiles,
I am using Excel 2003. I am looking for a way to hide/disable (don't care which) the Page Break Preview/Normal View button in the print preview screen. (Then of course unhide/enable when the window closes)
The reason is that my workbook has multiple hidden tabs and a few userforms. Eventually information placed in the userforms updates data on the hidden tabs and the user can open the print preview with a button on the userform. Currently if they press the Page Break Preview/Normal View button it drops them back to the excel tab and lets them view the previously hidden tab. I'm trying to prevent that.
Any help is greatly appreciated and as always thank you.
I am using Excel 2003. I am looking for a way to hide/disable (don't care which) the Page Break Preview/Normal View button in the print preview screen. (Then of course unhide/enable when the window closes)
The reason is that my workbook has multiple hidden tabs and a few userforms. Eventually information placed in the userforms updates data on the hidden tabs and the user can open the print preview with a button on the userform. Currently if they press the Page Break Preview/Normal View button it drops them back to the excel tab and lets them view the previously hidden tab. I'm trying to prevent that.
Any help is greatly appreciated and as always thank you.
