How to make Excel Add-in worksheets viewable?

[Asdf0qwerty]

Hi everyone,

I have this user defined function (UDF) add-in (.xla) that has worksheets in it. How do I make these worksheets viewable in an Excel workbook so I could put values and make use of it? TIA

 

[Richard Schollar]

I think you'll need to change the IsAddin property to False so that you can view and manipulate the worksheets in Excel - in the Immediate Window in the VBE type in (and press enter at the end):

Workbooks("YourAddinName.xla").IsAddin = False

this should make the sheets visible.

Change it back again to hide the worksheets.

 

[xld]

Why would youb want to do that? Addins are code applications, not data, so you shouldn't be storing user data in the worksheets. If you hold templates in the addin, just copy them to a user workbook.

 

[Asdf0qwerty]

@xld : Thank you for your reply. The worksheets have values in them. Like I have a data table with values which are necessary for my add-in computations. I apologize, what do you mean by templates?

 

[xld]

Well, you can stiill use those values in the addin for your compujtations without making tyhe sheets visible (but don't reference them in formulae, very bad!).

By templates I mean proo-forma sheets that you might use often so you have a template rather than recreate each time.