Disable page break preview

Experts,
I have a need to disable Page Break Preview at the workbook level. I have a user that is a good employee but insists on doing some things their way. I want to keep this person but doing things our way.
Frank FreeseAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
OK, you can do it using the admin templates in group policy (which you can download from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=64b837b6-0aa0-4c07-bc34-bec3990a7956&displaylang=en)
You need to set up a custom Disable Commands entry for the user's software permisisons using control ID 724 and that will disable the Page Break Preview button. I can't (as yet) see any way to disable the status bar option.
0
 
Frank FreeseAuthor Commented:
ok - where does this code need to be placed please - what sub routine?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Frank FreeseAuthor Commented:
I placed this code and did not get any changes - user can still change view to Page Break:

Private Sub Workbook_Open()
ActiveSheet.PrintPreview False
ActiveWindow.View = xlNormalView
End Sub
0
 
Rory ArchibaldCommented:
I don't believe you can do this - you can disable the button on the Ribbon easily enough, but not the one in the status bar (bottom right).
0
 
Frank FreeseAuthor Commented:
It is the ribbon I'm refering to -
0
 
Rory ArchibaldCommented:
What's the point of that if he can just use the status bar to turn it on? Also, I have to ask why this is an issue for you?
0
 
Frank FreeseAuthor Commented:
the issue is that these spreadsheets were not designed to be viewed except normal view. this person changes the view to the way they want it to be and saves the changes. others that use these workbooks are irrated by this and I can not seem to get this person to do this our way - changing the view is just one of the changes this person makes and I do not need someone here that does not want to be a part of the team
0
 
Rory ArchibaldCommented:
Ok, but what about the first question?
0
 
Frank FreeseAuthor Commented:
there's not a way to modify the status bar? if so, then disabling the ribbon is better than nothing so if you can help me with that I'd appreciate it.
0
 
Rory ArchibaldCommented:
Are you familiar with using Custom XML in workbooks to modify the Ribbon?
I'm also going to have a look at the admin templates for Group Policy to see if something can be done there.
0
 
Frank FreeseAuthor Commented:
thanks..I am very grateful for your help. Great job!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.