excel custom add ins

[Shippwreck]

Hi,

I'm relativley new to writing vba code but am getting along quite well with a lot of help from the help files.

anyway, i have now completed the macro and want it to run behind a button on a custom toolbar. The reason for this is so that no matter what sheet you open you'll still be able to run the macro with a click of a button.

To do this i realised you need to make it an excel add-in, so i copied the code into a blank worksheet opened up the vba editor, added a module and pasted the code, i then saved the file as an excel add-in file in the default directory. I then opened up an excel file and clicked add-ins... and put a tick next to my add-in.

So all seems good, except that now i can't work out how to run the add-in. So that you know it isn't a function rather more of a small program that finds certain values in the current sheet copies the row that they are in and pastes them into a new workbook that the code created.

Please help as i'm tearing my hair out cause i just want to run it properly.

thanks in advance

http://www.orlandoluxuryvilla-pool.com

 

[Dreamboat]

Hint: Did you create a menu or toolbar button to RUN the macro?

It's done very similarly to Word:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=14

Excel VBA Certification is Finally Here!

http://www.vbaexpress.com/forum