98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating Excel Sheet
Formating Excel Sheet
Resolved · Low Priority · Version 2007
Mon 22 Aug 2011, 16:27Delegate Ade said...
Ade has attended:
Project Intro Intermediate course
Visio Introduction course
Visio Advanced course
Excel Intermediate course
PowerPoint Intermediate Advanced course
Formating Excel Sheet
What can I do to allow users to view Excel sheet but not print the Excel sheet?
Tue 23 Aug 2011, 15:02Trainer Rachael said...
RE: Formating Excel Sheet
You can use a macro to do this. Press Alt & F11 to open the VBA for Excel editor. Double-click on ThisWorkbook in the left-hand panel. In the right-hand panel enter:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
Click on save icon and try and print now...
Tue 30 Aug 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + -. |
