Hi
have a look at the workbook sheetactivate event

--
Regards
Frank Kabel
Frankfurt, Germany


I know how to create the msgbox for the whole workbook so that when
you open the workbook the msgbox appears, thats fine. Is it possible
and if so how do I create a msgbox just for a sheet so that when it
is
selected a msgbox appears?


---
Message posted from http://www.ExcelForum.com/