Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet msgbox
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet msgbox
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet msgbox
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msgbox in sheet | Excel Discussion (Misc queries) | |||
MsgBox from another sheet | Excel Discussion (Misc queries) | |||
code to close an excel sheet without saving it .(via msgbox) | Excel Worksheet Functions | |||
Display MsgBox when selecting a sheet | Excel Discussion (Misc queries) | |||
msgbox | Excel Discussion (Misc queries) |