Hi
If I understand your setup correctly; you want some worksheet cells
containing descriptions to be invisible when you print the worksheet to
paper ? You would need to use the "BeforePrint" macro event for that, and
that's quite primitive. This is better:
Put textboxes from the Drawing toolbar over those cells, clear the cells and
type into the textboxes instead, they are your new labels. Rightclick the
textbox border and select Format Textbox, pane Properties. Unselect "Print
object" and select "move and size with cells".
(Apologies for all the guessing; Forms and Labels come in many variations on
computers)
HTH. Best wishes Harald
"Arthur F. Dunn, M.D." skrev i melding
...
I am currently using Excel in Office 2000. Is it possible to create a form
on screen and designate the form labels as non-printing while the data
cells
would print? i.e this would be necessary to use an on-screen form with a
preprinted form. I can hide the label cells but then they disappear from
view, defeating the usefulness of the on-screen form. Would a later Excel
version offer this capability?
|