Set the value of Application.OnSheetActivate
                HRESULT OleSetOnSheetActivate( const CString& strMacro );  | 
            
The new value of Application.OnSheetActivate which should be a macro name.
Header: xlpcom.h
CXllCom Class | CXllCom Methods | CXllCom::OleGetOnSheetActivate()