Sheet msgbox

[Fraggs]

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

 

[Frank Kabel]

Hi
have a look at the workbook sheetactivate event

 

[Bob Phillips]

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)