Cell Ghosts - Microsoft Suggestion

  • Thread starter Thread starter Geoff
  • Start date Start date
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
 
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
 
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
 
Back
Top