![]() |
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. |
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. |
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. . |
All times are GMT +1. The time now is 07:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com