Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating Excel Sheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formating Excel Sheet

Resolved · Low Priority · Version 2007

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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.

Excel articles

· Conditional Formatting in Excel 2007
· Make A Custom Sort List In Excel
· Discover The PMT, IPMT And PPMT Functions In Excel
· A Blinking Good Excel Tip
· How To Get The Best Out Of Excel With The Internet

Please browse our web site to find out more about
exce+training and other Microsoft training courses.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips