Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Storing Context Information in Cells

I'm looking for a way to store some conext information in cells along with
their value. I want to use the context to control which options available in
a custom right-click menu. I was considering storing information in the ID
field but the information gets lost when the file is saved and re-opened. Is
there some other cell property where I can store information associated with
a cell that the user won't see?

- Drew
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Storing Context Information in Cells

Perhaps on a hidden sheet in the corresponding cell.

--
Regards,
Tom Ogilvy



"Drew Lettington" wrote:

I'm looking for a way to store some conext information in cells along with
their value. I want to use the context to control which options available in
a custom right-click menu. I was considering storing information in the ID
field but the information gets lost when the file is saved and re-opened. Is
there some other cell property where I can store information associated with
a cell that the user won't see?

- Drew

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Storing Context Information in Cells

Thanks. I did consider creating a "shadow" worksheet but I want to be able
to get the context information even if the user moved cells in the original
worksheet.

- Drew

"Tom Ogilvy" wrote:

Perhaps on a hidden sheet in the corresponding cell.

--
Regards,
Tom Ogilvy



"Drew Lettington" wrote:

I'm looking for a way to store some conext information in cells along with
their value. I want to use the context to control which options available in
a custom right-click menu. I was considering storing information in the ID
field but the information gets lost when the file is saved and re-opened. Is
there some other cell property where I can store information associated with
a cell that the user won't see?

- Drew

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Storing TextBox info in cells, then retrieving on next load-up jlroper[_2_] Excel Programming 2 September 2nd 05 06:09 AM
Storing TextBox info in cells, then retrieving on next load-up T-®ex[_48_] Excel Programming 0 August 31st 05 07:51 AM
How to disable the "Insert Copied Cells" context menu item Coen Excel Programming 21 February 9th 05 09:37 PM
Storing additonal information for a cell Peter[_44_] Excel Programming 2 August 4th 04 07:48 AM
Excel VBA - Storing text in a variable, and "'Cells' of object _Global failed" engineer[_2_] Excel Programming 3 April 23rd 04 11:35 PM


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"