| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Comment Summary with Hyperlinks
I want to build a routine which checks all the cells in a workbook t see if any comments exist. I then want to print the cell addresses o each of these cells in a summary sheet AND as hyperlinks. For example: Sheet1!A1 Sheet21B4 Shee3!H678 So when I click onto Sheet1!A1 in this list, it will take me to tha cell. Does anyone know how to do this? Thn -- ExcelMonke ----------------------------------------------------------------------- ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522 View this thread: http://www.excelforum.com/showthread.php?threadid=27520 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use Hyperlinks inside an Excel cell's comment field? | Excel Worksheet Functions | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
![ExcelMonkey[_180_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
