Add-In to check workbook on open

[Vlip]

I have an application I wish to convert to an add-in. The macros in the application apply to only a specific type of workbook that I have identified by the title property. On open, there are a few operations I need to perform including adding the toolbar. I've tried the Autpen and Workbook_Open event procedures but they do not work. I get an "Object variable or With block variable not set" error. I believe this is because these event procedures are triggered when the add-in is opened and the actual workbook I want to refer to has not yet opened.

The code I am using is:
Private Sub Workbook_Open
If UCase(ActiveWorkbook.BuiltInDocumentProperties("Title")) = "TIME TRACKING TOOL" Then
....
End If

Anyone have any ideas?

Thanks,
Vlip

 

[BrianB]

The problem is to be able to trap the workbook_Open event at Application level. You could then check the ActiveWorkBook.Name.

This can be achieved by making a *Custom Class* using a *Class Module*. The solution is somewhere on an MVP website or J.Walkenbach etc. Not sure where. Do a Google search for those terms.

 

[Vlip]

I have J. Walkenbach's book and I already have a class module for trapping events. I use it to trap the before_print event. I will give that a try.

Thanks,
Vlip

 

[BrianB]

Here 'tis
http://www.cpearson.com/excel/AppEvent.htm