i have some easy questions in automation in c++ with excel

1. how can i catch closing operation of user of excel application or worksheet in c++.
2. how can i block cells data in excel to values i choose from c++, again...
3. how can i save a range in a worksheet to CString object?

thank you, amit.