how to save in the excel some additional invisible information
 

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

how to save in the excel some additional invisible information
 

Put the data in a cell with the background color the same as the font color
and make the cell both hidden and protected
--
Gary''s Student - gsnu200772


"Smugliy" wrote:

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

how to save in the excel some additional invisible information
 

I want that it will not be displayed at all !



"Gary''s Student" wrote:

Put the data in a cell with the background color the same as the font color
and make the cell both hidden and protected
--
Gary''s Student - gsnu200772


"Smugliy" wrote:

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

how to save in the excel some additional invisible information
 

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)



"Smugliy" wrote in message
...
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