disable page break preview button

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
 
M

Michel Pierron

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
 
G

Guest

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

LDStone

What event do we put the code that prevents users from switching to
page break preview?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Controlling Page Break Preview 7
Disabled all print option on Excel 2003 shared add-in vs 2005 1
Right click mouse menu in Page Break Preview mode 1
HPageBreak not working 4
Disable Page Break Preview Button 1
page break preview and form button 1
Page Break Preview 2

Top