Non printing cell?

Jac · May 22nd, 2002, 08:37 PM

I have a macro which makes a new copy of a book, then Paste Special - Values all sheets so there are no links and no formulas left. However I want to have a cell on the first sheet which says "Click here for Info", which brings up a comment type thing. Problem is, I don't want "Click here for Info" to print. If I put a text box over the cell, the user tends to click the text box rather than the cell, so no comment shows. I can't insert a button linked to a msg box macro as I would have to paste this macro into the new book and I want this book free of macros if possible. At present I have the cell coming up with a Validation message when clicked on, and a comment (set to Show) over the cell which says "Click Here for Info". However same problem as the text box - people are clicking inside the comment. Can't protect the sheet either - people need to be able to make changes. What I really need is a way to make the contents of a cell non-printing, or something! Any ideas?

sann0638 · May 23rd, 2002, 06:11 AM

Can you exclude the row from the Print Area?

Chris Davison · May 25th, 2002, 07:11 AM

how about this ? :

above you list of info, in a cell, put "double-click here for info"

(maybe shade it or something too)

then :

view
toolbars
customise
commands
tools.......... scrolldown the options

click the camera icon and drag it to your toolbar, you should now have a camera sitting on your toolbar

now highlight your "double-click here" cell and click the camera, this will take a snapshot of this cell

now go to where you want to show it as an image, click and drag to max size

if you don't like the format (opaque-ness, lines etc etc) right-click the new image and play around with the formats...... whilst you're in there, click on properties and deselct "print object" - it now won't print

when anyone double-clicks this image, it will take them to the source, which, of course, sits above your list of info

_________________
Hope this helps,
Chris
(Excel '97, Windows ME)

[ This Message was edited by: Chris Davison on 2002-05-25 06:13 ]

Jac · May 26th, 2002, 10:01 PM

This camera thing is the stuff - I actually already use the camera but had not realised it could do this!
Appreciated - will work a treat! Regards Jacqueline

May 23rd, 2002, 06:11 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Can you exclude the row from the Print Area? __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 08:37 PM	#1
Jac New Member Join Date: May 2002 Location: Melbourne, Australia Posts: 37	I have a macro which makes a new copy of a book, then Paste Special - Values all sheets so there are no links and no formulas left. However I want to have a cell on the first sheet which says "Click here for Info", which brings up a comment type thing. Problem is, I don't want "Click here for Info" to print. If I put a text box over the cell, the user tends to click the text box rather than the cell, so no comment shows. I can't insert a button linked to a msg box macro as I would have to paste this macro into the new book and I want this book free of macros if possible. At present I have the cell coming up with a Validation message when clicked on, and a comment (set to Show) over the cell which says "Click Here for Info". However same problem as the text box - people are clicking inside the comment. Can't protect the sheet either - people need to be able to make changes. What I really need is a way to make the contents of a cell non-printing, or something! Any ideas?

May 25th, 2002, 07:11 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	how about this ? : above you list of info, in a cell, put "double-click here for info" (maybe shade it or something too) then : view toolbars customise commands tools.......... scrolldown the options click the camera icon and drag it to your toolbar, you should now have a camera sitting on your toolbar now highlight your "double-click here" cell and click the camera, this will take a snapshot of this cell now go to where you want to show it as an image, click and drag to max size if you don't like the format (opaque-ness, lines etc etc) right-click the new image and play around with the formats...... whilst you're in there, click on properties and deselct "print object" - it now won't print when anyone double-clicks this image, it will take them to the source, which, of course, sits above your list of info _________________ Hope this helps, Chris (Excel '97, Windows ME) [ This Message was edited by: Chris Davison on 2002-05-25 06:13 ]

May 26th, 2002, 10:01 PM	#4
Jac New Member Join Date: May 2002 Location: Melbourne, Australia Posts: 37	This camera thing is the stuff - I actually already use the camera but had not realised it could do this! Appreciated - will work a treat! Regards Jacqueline