View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Do not print one cell question?

Hi,

I'm not sure what you want, but you can select the cell (when its not
protected) and choose Format, Cells, Custom on the Number tab and on the
Code line enter ;;; (three semi-colons)

Cheers,
Shane Devenshire
Microsoft Excel MVP


"LiveUser" wrote in message
...
I have my worksheet protected so only certain cells can be selected. I
will
send this worksheet to others to collect data and send the information
back
to me on the same worksheet. In some cases, people will not use the form
within Excel and will print the form. When the Excel worksheet is printed
I
want it to not print one cell. This cell is calucalated automatically
within
Excel and I don't want people making an attempt at the calculation. Is
there
a way print the worksheet/form and not print the one cell?

Thank you.