Pop Up dialog boxes in a work sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spelling checker problem on a specific worksheet only 1
Excel Providing user message when RED X clicked & properly closing application. 2
Excel-2007 does not support Charts in Dialog Sheets 2
add personal template to the insert worksheet dialog box 2
Invalid References in formula 3
How do I change a pop-up dialog box in an Excel cell? Not comment 1
Save generates unprotect sheet dialog box 1
How do I display a dialog box that pops up when you first open exc 4

Back
Top