Add In menu to run a macro

[seabass]

Ok, thanks to DaveExcel, i am getting some headway on this one. Here is some more questions on how to ....

So here is the vision...... We are trying to give non-programmer users the ability to do an effective search on a worksheet. Worksheets are generated overnight using Business Object and Crystal Reports. Every day some users will open the spreadhseet through a link on a web page.

When the user open the spreadhseet, it has no formatting build in for searching the data. Thanks to a previous helper on here, this has been resolved, but i do not know what will be the best way to give all users the ability to install the search box the way it is currently setup in the attached spreadhseet.

Any help will be appreciated !

[royUK]

You can't just install the code. You would probably be better off having a master workbook then import the data into that.

Alternatively, you could have a different approach using a UserForm to set up the Filter Criteria. The UserForm could be in an addin that everyone could have installed. Something like this

You would need a menu to call the form

[SDruley]

I must admit that your thinking is very clever and out of the box.
One of the things you might consider is, at least with most browsers, a

Please Login or Register  to view this content.

will allow you to search the content of a web page with lightening speed, whether it is a "Material Master", "BinNumber" or whatever. If a particular field is sorted before the search is done then the data will be grouped in a way that you have done here.

Just some thoughts...

[seabass]

Good point.... I like the form idea, it actually look pretty good.

So because the files is updated overnight, all i need is a addin right ???? then i could use "Ctrl-F to open the form ?????

How can i share a addin and have it so it is really easy to turn on and turn off.....???? I have to keep it as simple as possible as most users are not as computer savvy as folks on here.....

Any help is truly appreciated,

Seabass

[royUK]

You create the form in a new workbook. Add the code for a menu that calls the form, then save it as a addin. Make sure you change the save to destination so that you can find it. The addin is then very simple to install,simply distribute a copy to allusers.

In Excel,Tools Menu -> Addins -> browse.Find the addin & click OK.

[seabass]

Hi there....

This is a little more complicated than i expected....
So i downloaded the addmenu code, i am able to run the macro and create the menu in the Add in ribbon. Problem is that every time i close the workbook, the menu item goes away....

So i need the menu in the add ins to say 2 things.... insert filter and remove filter... the insert filter will be a macro that insert a text box in cell a1. This textbox will allow me to autofilter .... i guess i wish i could click on insert filter and it will automatically add a text box and the autofilter code for the first 20 column...... I feel like i have been asking a lot but i really need this...

Thanks in advance.