Message on Activated window is Myworkbook.

[naveenmarapaka]

Hi I need a solution to my problem.

My Current workbook name is MyTest.xlsm, we usually switch around our all current opened windows applications using Key strokes ALT +TAB.

I want a message saying "Your workbook is opened" when ever current active windows application on my desktop screen is my workbook which is MyTest.xlsm.


where should I write a code ( like in a normal module or in sheet module) and what should be the code.

[Olly]

Put this in the "ThisWorkbook" module of MyTest.xlsm

Please Login or Register  to view this content.