how to save in the excel some additional invisible information

[Smugliy]

Hi ,

Can you plese told me ,how I can save in the excel some additional invisible
information ,for example ,connection string or some string .
I want to do it using VSTO ,so any other time when I load my Excel document
,I can read (with code) this information.

But once again it should be invisible to ALL Users

Thanks a lot

 

[Gary''s Student]

Put the data in a cell with the background color the same as the font color
and make the cell both hidden and protected

 

[Smugliy]

I want that it will not be displayed at all !

Put the data in a cell with the background color the same as the font color
and make the cell both hidden and protected

 

[Chip Pearson]

At least two methods come to mind, Defined Names and Custom Document
Properties.



--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)