Printing comments

Posted by Steve Mathews on January 09, 2002 8:15 AM

Not a dev question but I figured this was the best place to ask. Is there any way to show cell comments on a printout? If not how hard would it be to have a macro move the comment into the cell it is on so it can be printed? I think I could figure that one out but it would be nice to just be able to print them.
Thanks,
Steve

Posted by faster on January 09, 2002 8:31 AM

goto File/Page Setup/Sheet (tab)

you can select what to print there.

Posted by Scott on January 09, 2002 8:34 AM

If you go File-Page Setup, and then select the "Sheet" tab. You will see a drop down box for "Comments". You can pick "At End of Sheet", "As Displayed on Sheet", or "None".

Posted by Steve Mathews on January 10, 2002 5:57 PM

Guess I missed that. Thought I had looked there.

Thanks,
Steve