| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pop Up dialog boxes in a work sheet
I would like to insert a dialog box with a message in when a particular sheet
of a workbook is opened, which contains a message and an ok button (in order to close the dialog box and consequently to allow the sheet to be edited). Is this possible to do, and if so, how? Many thanks in advance. G |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pop Up dialog boxes in a work sheet
Hi,
As an example, when the worksheet is activated ... Private Sub Worksheet_Activate() CreateObject("WScript.Shell").Popup "Welcome", 10, _ "Good Morning" Close End Sub HTH Cheers Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| does any one know how to convert a scanned sheet to a work sheet | Charts and Charting in Excel | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
