VB and VBA Users Source Code: Prevent the user changing settings in Excel's Print Preview Mode
[
Home
|
Contents
|
Search
|
Reply
| Previous |
Next
]
VB/VBA Source Code
Prevent the user changing settings in Excel's Print Preview Mode
By:
Andrew Baker
Email (spam proof):
Email the originator of this post
Date:
Sunday, July 30, 2000
Hits:
869
Category:
Unspecified
Article:
If you don't want the user to be able to modify any of the page settings in Excel, when in Print Preview mode then use the following code: 'Purpose : Prevents the user from making any changes in Print Preview mode. 'Inputs : N/A 'Outputs : N/A 'Author : Andrew Baker 'Date : 25/03/2001 'Notes : Shows the Active Window in Print Preview mode Sub PrintPreviewDisable() 'The False parameter prevents changes in Preview mode. ActiveSheet.PrintPreview False 'Prevent user switching to "Page Brake Preview". ActiveWindow.View = xlNormalView End Sub
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
