all excel workbooks must have at least on sheet. An addin is a special
workbook.

you can reference the sheet the same as you would any sheet (without
selecting)

set sh = Workbooks("MyAddin.xla").Worksheets(1)
sh1.Range("A1").Value = 10

or for code within the addin

set sh = thisworkbook.worksheets(1)



--
Regards,
Tom Ogilvy


"big t" wrote:

hi everyone,

i always thought that xl add-ins do not have worksheets, but in the vbe i
can see Sheet1 (Sheet1) under Microsoft Excel Objects under my add-in.

and the 'Visible' property for this worksheet is -1 - xlSheetVisible.

basically, i want to use my add-in to store some options for the user, and
i'm looking for the easiest way to do this. i don't really want to mess
around with the registry or ini files if i can avoid it and i figured that if
there is a useable sheet in the add-in i can use that.

TIA,
big t