BrighterLater
Board Regular
- Joined
- Sep 16, 2005
- Messages
- 114
I was hoping to use comments, attached to a cell, as a way of storing my own properties against the cell. But .visible = false does not hide them completely; as soon as the cursor hovers over the cell the comment pops up (as designed of course). I would like to make them more invisible.
Alternatively, if anyone can suggest a way of storing information against a cell in another way then I'd be most grateful.
Here is another way but it's more complex: This would involve naming the cells, something like myprop0001, myprop0002 etc. I would then create a collection which contained object from a class module with myprop001(etc) as its name and index. I could then add whatever properties I needed to this object. However if possible I would prefer a simpler solution than this because I have round about 6000 of them and am concerned about performance.
Thank you for your assistance.
Alternatively, if anyone can suggest a way of storing information against a cell in another way then I'd be most grateful.
Here is another way but it's more complex: This would involve naming the cells, something like myprop0001, myprop0002 etc. I would then create a collection which contained object from a class module with myprop001(etc) as its name and index. I could then add whatever properties I needed to this object. However if possible I would prefer a simpler solution than this because I have round about 6000 of them and am concerned about performance.
Thank you for your assistance.