hi
i have an instructional cell containing text for guidance for the end user, which when they print the worksheet i would like to be hidden/unprinted. how can i do this?
cheers
hi
i have an instructional cell containing text for guidance for the end user, which when they print the worksheet i would like to be hidden/unprinted. how can i do this?
cheers
put the guidance in the form of a note attached to the cell, leaving the actual cell blank.....or...
write a macro that copies the contents of the cell to an unused cell outside the print area, and incorporate that macro in a dedicated print macro, run from a suitable icon, the end of the macro will obviously copy the text back into the cell.
You could add a workbook event macro.
Link should help with the code. look under "Make the Font white of a range"
http://www.rondebruin.nl/print.htm#Hide
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
cheers guys
millsy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks