Workbook Popup note

[Guest]

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.

 

[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

 

[Guest]

Thanks very much - it works perfect.
--
Carolan

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