print hidden values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeannine - 05 Sep 2006 21:19 GMT

I have a spreadsheet that has two cells that I have hidden by going into
format cells to number and typed ;;; (3 semicolons) in the type box.

I would like to be able to have the sheet print without the value showing on
the screen. Does anyone know how to set a macro to allow hidden cells to
print?

Reply to this Message

Earl Kiosterud - 05 Sep 2006 23:37 GMT

Jeannine,

This might do it:

Sub PrintWithHidden()
Application.ScreenUpdating = False ' Prevent screen from showing hidden
stuff while printing
Range("A2").NumberFormat = "General" ' or whatever is appropriate for
printing the hidden cell
ActiveSheet.PrintOut
Range("A2").NumberFormat = ";;;" ' set it back
Application.ScreenUpdating = True
End Sub

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>I have a spreadsheet that has two cells that I have hidden by going into
> format cells to number and typed ;;; (3 semicolons) in the type box.
[quoted text clipped - 3 lines]
> the screen. Does anyone know how to set a macro to allow hidden cells to
> print?

Reply to this Message