Solved

Disable page break preview

Posted on 2011-02-17
12
940 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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
 

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

627 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