disable page break preview button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

need code to disable the page break preview and help buttons on the top menu
bar that opens when you click on print preview . . . i can disable buttons at
the print preview level but can't seem to get the code right to go down to
the next menu bar . . . any help will be appreciated
 
Hi codysphantom;

' The False parameter prevents changes in Preview mode.
ActiveSheet.PrintPreview False
' Prevent user switching to "Page Brake Preview".
ActiveWindow.View = xlNormalView

Regards,
MP
 
Michel . . .
Thanks.
codysphantom

Michel Pierron said:
Hi codysphantom;

' The False parameter prevents changes in Preview mode.
ActiveSheet.PrintPreview False
' Prevent user switching to "Page Brake Preview".
ActiveWindow.View = xlNormalView

Regards,
MP
Click to expand...
 
Back
Top