Solved

Disable page break preview

Posted on 2011-02-17
12
905 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:Frank Freese
  • 6
  • 5
12 Comments
 
LVL 17

Expert Comment

by:gtgloner
ID: 34915990
0
 

Author Comment

by:Frank Freese
ID: 34916044
ok - where does this code need to be placed please - what sub routine?
0
 

Author Comment

by:Frank Freese
ID: 34916255
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34916770
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
 

Author Comment

by:Frank Freese
ID: 34918208
It is the ribbon I'm refering to -
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34918409
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Frank Freese
ID: 34918755
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34918883
Ok, but what about the first question?
0
 

Author Comment

by:Frank Freese
ID: 34920742
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34921577
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
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 34921756
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
 

Author Closing Comment

by:Frank Freese
ID: 34923350
thanks..I am very grateful for your help. Great job!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Hiding column macro 10 28
Auto populate in Cascade dropdown 3 27
Mac Excel column treating text as date 2 31
Most Consistent Performer 4 20
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now