dialog box with text.

L

Leo Rod

Hi All !

I would like to have a dialog box with a reminder everytime I open an
Spreadsheet.
Please let me know if anybody knows the VB for this, I'm clueless on that
lenguage.

Thanks in advance and greetings,

Leo.
 
G

Gord Dibben

Place this code in Thisworkbook module.

Private Sub Workbook_Open()
MsgBox "Have you brushed your teeth today?"
End Sub

To open Thisworkbook module, right-click on the Excel Icon left of "File" on the
menu bar.

Select "View Code" and copy/paste the above into the blank module.

Save and close the workbook.

When you re-open the message should appear.


Gord Dibben MS Excel MVP
 
Top