How best to distribute search tools with workbook?

[Ed]

I create a workbook which goes onto a shared network drive. In the
workbook, I have several search tools (most created with the wonderful help
of the gurus here!). Right now, each of these search tools is on a separate
page of the workbook, three pages which contain nothing more that a text box
explaining that search, a button to start it, and code in the sheet. All
the data being searched is on the first page.

I was trying to think of a better way to do this. Maybe a Userform with a
Multipage, with each search on a different multipage. I think I can do
this, but I'm not sure of two things:
(a) how to include this with this workbook only, without requiring the
user to put an Add-In in their own personal Excel?
(b) how to create a toolbar with a "Search Tools" button only when
this workbook is active?

Or - would it be easier (and make a smaller workbook) if I kept it as is?

Your thoughts are appreciated.
Ed

 

[Tom Ogilvy]

Just adding a userform in your current workbook and adding a button to
display it should do what you want. Doesn't require an addin and using an
addin would be more difficult.

Trying to have a context sensitive commandbar would be more of a challenge.

 

[Ed]

Thanks, Tom, for helping. I can do the UserForm. I'm unsure about the
button, though. Are you taking about just a Command Button on the
worksheet? I was thinking about a ToolBar that would show at Open, and
remove itself at Close.

When I added these search tools into the workbook, I thought it was a good
thing to have each on a page with a titled tab - my users know what is
available to them, or at least that *something* is available. If there's
just one button at a specific point on the worksheet, if some of these
people are down the sheet a ways - well, out of sight, out of mind, and for
many it's not a very long trip! If there was a brand new toolbar pop up
with a "Search Tools" button, they might actually notice that (as opposed to
calling me to find out why I took the searches off!).

From your experience, what would you recommend?

Ed