Pop Up dialog boxes in a work sheet

G

G and (ajk)

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
 
C

Carim

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
 
Top