ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Storing additonal information for a cell (https://www.excelbanter.com/excel-programming/305916-storing-additonal-information-cell.html)

Peter[_44_]

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.



Nick Hodge

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.





Fank Kabel

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