Cell Ghosts - Microsoft Suggestion

G

Geoff

It would be great if you could ghost a cell. By this I mean store
information in a cell which is not displayed to the user. This would allow
information in addition to the cell data to be kept. This technique could
open up a lot of applications and would be accessed through VBA.

If this can be done then could someone let me know, but I do not need to do
this through Comments or Lists. The technique needs to work on the cell
object itself.

Thanks
 
B

Bernie Deitrick

Geoff,

You can't do what you want the way you want. You can always insert a
hidden worksheet that you use in your application to store the data in
the same (relative) cell.

HTH,
Bernie
MS Excel MVP
 
C

ceplane

What I did was to format the cell, (right click on the cell) click o
protection,click on hide, then protected the sheet. Any formulas i
that one cell is now hiden. Hope thats a help
 
Top