Hide two cells until print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to hide the contains of two cells when on the screen
but have it show when it is printing.

Anybody have any ideas?
 
Give it a white font, and in the Workbook_BeforePrint event, change the font
to black, set up an ontime event to turn it back to white after printing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to hide rows if cell in another WS is ="No" 11
Hide Unhide Button 4
checkbox problem 22
Printer Problem... Epson Stylus Photo R200 4
Canon IP 6600D Photo Printer 2
Epson XP-3150 not printing 2
Macro to insert a line when a value changes in a range 1
Hiding $ on a spreadsheet 1

Back
Top