How to check if different workbook has been activated

[winxpdows]

I've built an addin to give my users different functions depending on which workbooks they are using. There are two different types of workbooks we use. Type A gets a certain set of commands, Type B gets others.

I have a custom menu and want to check when the user switches in between different workbooks (switching, opening or closing) in order to enable/disable the correct commands for which workbook they are in.

How do I check when the activeworkbook has changed from my addin? I want to run a macro whenever a different workbook has been activated


Thanks in advance for any help!!!

 

[pedie]

Maybe

[FONT=Courier New]Debug.print Activeworkbook.Name[/FONT]

 

[winxpdows]

Thanks pedie,

That gives me the active workbook name, but I don't know how to check that against anything. I'm hoping to find a way that I can run a macro whenever the active workbook has changed to another one.