Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cells to a comment
i want to use a comment as a guide to entering codes into a
spreadsheet. problem is, the codes change depending on conditions in the sheet. can i create a table of codes that use logic statements to change as conditions change, then link this table to a comment? i tried the copy picture command, but cant get the picture into a comment. is there a way to do this? thanks Tonso |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cells to a comment
Based on the last line of your posting, see
Add a Picture to a Comment http://www.contextures.com/xlcomments02.html#Picture --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Tonso" wrote in message ups.com... i want to use a comment as a guide to entering codes into a spreadsheet. problem is, the codes change depending on conditions in the sheet. can i create a table of codes that use logic statements to change as conditions change, then link this table to a comment? i tried the copy picture command, but cant get the picture into a comment. is there a way to do this? thanks Tonso |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cells to a comment
David,
how do i save an excel "copy - picture" as a file so i can add it as a picture to a comment? thanks, Tonso Tonso wrote: i want to use a comment as a guide to entering codes into a spreadsheet. problem is, the codes change depending on conditions in the sheet. can i create a table of codes that use logic statements to change as conditions change, then link this table to a comment? i tried the copy picture command, but cant get the picture into a comment. is there a way to do this? thanks Tonso |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cells to a comment
Hi Tons,
Depends on how labor intensive and/or how cheap you want it, or how professional you need it. One way -- would be to use techniques on http://www.mvps.org/dmcritchie/excel/xl2gif.htm I expect that some of the solutions in the related area may be better solutions now, Also some comments have been added, several regulars in the newsgroups have add-ins (which I presume are free) http://www.mvps.org/dmcritchie/excel/xl2html.htm I would use an application that can grab a screen shot and put it to the clipboard or to a file as needed. One such application is SnagIt [-- http://www.techsmith.com/snagit.asp --], which I use, and is pay for software, A free alternative is Screenshot Captor [-- http://www.donationcoder.com/Softwar...tor/index.html --]. All such alternatives allow you annotate what you extracted. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tonso" wrote how do i save an excel "copy - picture" as a file so i can add it as a picture to a comment? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cells to a comment
David,
Thank you so very much for your response! I am looking at the alternatives you suggested and wil select the one that best suits my needs! Thank heavens for MVPs!! Tonso David McRitchie wrote: Hi Tons, Depends on how labor intensive and/or how cheap you want it, or how professional you need it. One way -- would be to use techniques on http://www.mvps.org/dmcritchie/excel/xl2gif.htm I expect that some of the solutions in the related area may be better solutions now, Also some comments have been added, several regulars in the newsgroups have add-ins (which I presume are free) http://www.mvps.org/dmcritchie/excel/xl2html.htm I would use an application that can grab a screen shot and put it to the clipboard or to a file as needed. One such application is SnagIt [-- http://www.techsmith.com/snagit.asp --], which I use, and is pay for software, A free alternative is Screenshot Captor [-- http://www.donationcoder.com/Softwar...tor/index.html --]. All such alternatives allow you annotate what you extracted. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tonso" wrote how do i save an excel "copy - picture" as a file so i can add it as a picture to a comment? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions | |||
How to link cells only if... | Excel Discussion (Misc queries) | |||
Problem with link cells between 2 spreadsheets | Excel Discussion (Misc queries) | |||
How to link cells and keep number format altogether | Excel Discussion (Misc queries) |