thanks for your answers.

just one more question...

....how come i can't see the sheets even though they are allegedly visible?

cheers
big t

"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