Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing additonal information for a cell
Hi,
Does anyone know if it is possible to store additional "programmer defined" information against individual cells? I have an application and want to store hidden data for each cell in the spreadsheet itself. Could I maybe use smart tags for this? Thanks, Peter. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing additonal information for a cell
Peter
You'll doubtless get a ton of suggestions for this but I would use range names. Most of what you do will be difficult to hide from the user totally though -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Peter" wrote in message ... Hi, Does anyone know if it is possible to store additional "programmer defined" information against individual cells? I have an application and want to store hidden data for each cell in the spreadsheet itself. Could I maybe use smart tags for this? Thanks, Peter. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing additonal information for a cell
Hi
never have used smarttags (but I assume you'll have problems with downward compatibility). some ideas: - use a comment (and hide the comment indicator) - use a defined name (made invisible) - use a hidden sheet -----Original Message----- Hi, Does anyone know if it is possible to store additional "programmer defined" information against individual cells? I have an application and want to store hidden data for each cell in the spreadsheet itself. Could I maybe use smart tags for this? Thanks, Peter. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Storing formula in cell | Excel Discussion (Misc queries) | |||
Storing an array in a cell | Excel Worksheet Functions | |||
Storing a range variable in a cell | Excel Discussion (Misc queries) | |||
storing lettrs in an excel cell to later = a number for a formula | Excel Discussion (Misc queries) | |||
Storing Cell Values in Access | Excel Programming |