Creating an addin and posting to other PCs

[lynnnow]

Hi,

I've created an addin that searches the entire workbook for a given string. It works perfectly on my pc. However, the problem is that when I copied it to another pc for testing, the xls file that I created the macro in was getting referenced and it just failed to show the menu item that I had created in the xla and also the macro doesn't show in the run macro dialog box to run it manually.

I've attached the xla for you guys to look at and tell me where i've gone and done something wrong.

Any pointers will be appreciated.

Thanks and regards,

Lynnnow

[Dave]

You need to add a workbook open event to the XLA that shows your userform. Dave

[lynnnow]

Hi Dave,

Does the workbook open event have to be in the addin that references the xls file or how. A little more clarification on this point would be helpful.

Thanks and regards,

Lynnnow

[Dave]

Paste this in your workbook code. Dave
[VBA]
Private Sub Workbook_Open()
Call Search_All
End Sub

[/VBA]
edit(x2): paste in XLA and save then re-open

[mdmackillop]

Hi Lynnnow,
Just for your info, I created this KB ( http://vbaexpress.com/kb/getarticle.php?kb_id=195 ) to search and return all instances of a string. There is an XLA version in for approval at the moment, with a little more functionality if this is of any interest.
Regards
MD