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

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

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/

Frank' suggestion will apply to al sheets. If you want it to apply to just
one sheet use the Worksheet_Activate event, and put the code in that
worksheet code module. Be aware that if you close the workbook with that
worksheet active, when you open the workbook again, that sheet will be
displayed, but it does not trigger the activate.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
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/