Workbook Popup note

C

Carolan

Is is possible to add a note that pops up as soon as I open a workbook. I
have workbook#1 that is linked to another workbook#2. I want to remind
myself not to make change until I open Workbook #2.
 
C

Chip Pearson

You can do this with VBA. Open the VBA Editor (ALT+F11), open the
ThisWorkbook code module, and enter the following:

Private Sub Workbook_Open()
MsgBox "Open other workbook"
End Sub

This code will run whenever the workbook is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
C

Carolan

Thanks very much - it works perfect.
--
Carolan


Chip Pearson said:
You can do this with VBA. Open the VBA Editor (ALT+F11), open the
ThisWorkbook code module, and enter the following:

Private Sub Workbook_Open()
MsgBox "Open other workbook"
End Sub

This code will run whenever the workbook is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Top