Showing sheets and forms, not running macros, from add in

**JP Romano** · 09-28-2009, 08:36 AM

Follow up from this post regarding usage of an add in for distribution purposes:

I now have the spreadsheet I want to distribute saved as an add in stored in a network repository. RoyUK has provided me with some links with code I lifted to add custom menu items. The last problem I have is that I'm not trying to call a macro, but am instead trying to load the sheets (there are 4 sheets) and forms (there are 7 forms).

With what I have now, I can launch a macro with no problem, but cannot get the sheets / forms displayed to the user. I've tried launching a form by loading / showing it, but I get error message (runtime error 9).

Any idea how I can get my sheets to load?

**royUK** · 09-28-2009, 08:45 AM

If you mean UserForms then there should be no problem.

You cannot show sheets from an addin, you would need to copy hem to another workbook.

**JP Romano** · 09-28-2009, 08:50 AM

Thanks Roy... guess that kind of kills my idea then.

I'll see if I can come up with a better way to distribute the tool. Apparently, my users don't like getting a new version every other week that they have to download from an email (even though they've told me it saves them HOURS of manual work every week when they use it)!

Thanks for your help and input. As always, you rock sir!

**royUK** · 09-28-2009, 09:02 AM

The code/userforms should be in an addin, any sheets that require input should be in a workbook, this woud not need updating.

You just need to be sure to specify the workbook to work with