Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Store information
I am creating a Excel Plugin. I want to store some information regarding the
user who creates that excel and the person who modify it subsequently. I want to store this info in some hidden way, available to be viewed only thought a custom menu item/ dialog box I create. This is possible in word using the ".variable" property where in i can create a "embedded" variable in the document and can refer to it programatically. I dont see any such facility in Excel. Any Comments/ Suggestion will be useful. -Satin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Store information
Hi
Their is nothing like the .Variable property in Excel. The easiest thing to do (and the most accessible for you) is keep such information on a hidden sheet. You can make this very hidden (so that it cannot be unhidden from the menu bar) using worksheets("Notes").Visible = xlVeryHidden code will unhide it worksheets("Notes").Visible = TRUE but you won't see the sheet in the collection of hidden sheets if you try and go look for it. regards Paul On May 3, 7:48 am, Satin wrote: I am creating a Excel Plugin. I want to store some information regarding the user who creates that excel and the person who modify it subsequently. I want to store this info in some hidden way, available to be viewed only thought a custom menu item/ dialog box I create. This is possible in word using the ".variable" property where in i can create a "embedded" variable in the document and can refer to it programatically. I dont see any such facility in Excel. Any Comments/ Suggestion will be useful. -Satin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Store information
Thanks Paul.
This is the last resort I have. It is quite surprising that Excel does not provide any such feature while it is present is word(.variable) and powerpoint(.tag). Same Owner.. different models ..!! Hail MS. Cheers ;-) -Satin " wrote: Hi Their is nothing like the .Variable property in Excel. The easiest thing to do (and the most accessible for you) is keep such information on a hidden sheet. You can make this very hidden (so that it cannot be unhidden from the menu bar) using worksheets("Notes").Visible = xlVeryHidden code will unhide it worksheets("Notes").Visible = TRUE but you won't see the sheet in the collection of hidden sheets if you try and go look for it. regards Paul On May 3, 7:48 am, Satin wrote: I am creating a Excel Plugin. I want to store some information regarding the user who creates that excel and the person who modify it subsequently. I want to store this info in some hidden way, available to be viewed only thought a custom menu item/ dialog box I create. This is possible in word using the ".variable" property where in i can create a "embedded" variable in the document and can refer to it programatically. I dont see any such facility in Excel. Any Comments/ Suggestion will be useful. -Satin |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Store information
Word and powerpoint are about text, while Excel is about data would be
the rationale I suppose? The easiest place to keep data is on a worksheet, so why reinvent the wheel?? Paul On May 3, 9:37 am, Satin wrote: Thanks Paul. This is the last resort I have. It is quite surprising that Excel does not provide any such feature while it is present is word(.variable) and powerpoint(.tag). Same Owner.. different models ..!! Hail MS. Cheers ;-) -Satin " wrote: Hi Their is nothing like the .Variable property in Excel. The easiest thing to do (and the most accessible for you) is keep such information on a hidden sheet. You can make this very hidden (so that it cannot be unhidden from the menu bar) using worksheets("Notes").Visible = xlVeryHidden code will unhide it worksheets("Notes").Visible = TRUE but you won't see the sheet in the collection of hidden sheets if you try and go look for it. regards Paul On May 3, 7:48 am, Satin wrote: I am creating a Excel Plugin. I want to store some information regarding the user who creates that excel and the person who modify it subsequently. I want to store this info in some hidden way, available to be viewed only thought a custom menu item/ dialog box I create. This is possible in word using the ".variable" property where in i can create a "embedded" variable in the document and can refer to it programatically. I dont see any such facility in Excel. Any Comments/ Suggestion will be useful. -Satin- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Store hidden information in Excel throw Add-In | Excel Discussion (Misc queries) | |||
Store hidden information in a spreadsheet | Excel Programming | |||
Using a Cube to store Histogram information? | Excel Programming | |||
Store Information but not in a Workbook | Excel Programming | |||
store some of the information from one cell into another | Excel Discussion (Misc queries) |