Brian,

A workbook is defined as a file containing at least one worksheet - that is eaht Exel is. Anyway,
it is very common to use the worksheet to store information.

Simply use code like

ThisWorkbook.Worksheets("Sheet1").Range("A1").Valu e = "Value I want to store"


You could also change the codename of the worksheet and shorten that to

SheetCodeName.Range(".....


HTH,
Bernie
MS Excel MVP


"Brian Herbert Withun" wrote in message
...
I have created a .XLA excel add-in and everything is going fine.

In the VBA Project I can see the Module and the Workbook that comprise
the XLA when I look at the Project heirarcy. I also see a worksheet
represented there in the hierarchy. I can't imagine why the XLA has
*any* sheets associated with it, and I can't seem to access that sheet
in any way.

Does anyone know why it's listed there as part of the XLA, and what
purpose it has?

Can I use this sheet to store values that will persist across
sessions? I'm thinking I might be able to store my add-in licensing
information there, but again, I can't seem to access anything on, in,
or from that Worksheet (Sheet1).

Kind Regards,

Brian Herbert Withun