Search results for query: *

Tony, you genius you! I didn't notice the part about the code module earlier. For some reason that worked like a charm for me... thanks :)

...oh, and the code is as seen above. The actual code that i want to run is quite different from a msgbox but I wrote this simple code to see if i could reproduce the problem

I've already tried using thisworkbook.doitnow, i've tried application.thisworkbook.doitnow and myproject.myworkbook.doitnow as well. Combo, As I said earlier. The add-in itself works fine (that is installing and uninstalling it), the code in the Install and Uninstall events do what they're...

The add-in IS installed, otherwise I wouldn't even have the menu item to click...

The code for adding and removing the menu (ie, the AddinInstall and AddinUninstall events) is fired when you select the addin under the tools menu. If you select the addin it will be loaded the next time as well. To actually get it working as an addin is not the problem though, i can't get it to...

Hi, I'm trying to create an add-in for Excel 2000 with VBA, but can't seem to get past even the first obstacle. I add this to the workbook code: Private Sub Workbook_AddinInstall() Dim asdf As CommandBar Dim qwer As CommandBarButton Set asdf =...

Thanks a lot. To expand on the question...if I add a row to a table called USER_INDEX I get an unique IndexID (primary key). How can I pass the indexID to the second table and name the new field indexXXX where XXX is the IndexID from the first table?

Hello, How would i create a trigger that adds a column to one table when a row is inserted into another table? Thanks