Set Workbook to invisible?
 

I have a workbook which contains all the text used by my Add-In. I use this
for localizing into other languages. My add-in opens this workbook and uses
it in conjunction with a GetString routine. I don't want this workbook to be
visible in the users Excel workspace. I accomplish this now by setting the
"IsAddin" property of my language workbook to True after I open it. A
problem with this is that if you try to open the language sheet - to
translate into another language - it does not show up - I guess because it
thinks it is an Add-In. Further - when you select Tools/Add-Ins - the
language sheet shows up as an Add-In. - but it is not really an Add-In per
say.

I may end up reading all the strings in once (there are not that many) and
not keeping the language workbook open. However, if you know of a cleaner
way to this - Workbook.Visible = False..Please let me know.

Thanks,
Steve

Set Workbook to invisible?
 

Steve,

Why do you need another workbook at all? By this I mean, why not just store
this data in the real addin, you don't need to make it visible to access it.
I have many addins that I use to store menu data and then I build a menu
from that data when the addin is loaded. Don't forget, an addin is still a
workbook, just not a visible one.

--

HTH

Bob Phillips

"S. Daum" wrote in message
...
I have a workbook which contains all the text used by my Add-In. I use
this
for localizing into other languages. My add-in opens this workbook and
uses
it in conjunction with a GetString routine. I don't want this workbook to
be
visible in the users Excel workspace. I accomplish this now by setting the
"IsAddin" property of my language workbook to True after I open it. A
problem with this is that if you try to open the language sheet - to
translate into another language - it does not show up - I guess because it
thinks it is an Add-In. Further - when you select Tools/Add-Ins - the
language sheet shows up as an Add-In. - but it is not really an Add-In per
say.

I may end up reading all the strings in once (there are not that many) and
not keeping the language workbook open. However, if you know of a cleaner
way to this - Workbook.Visible = False..Please let me know.

Thanks,
Steve