how can i have a pop-up window as soon as i open a certain spreadsheet...
J just1creation Jul 20, 2006 #1 how can i have a pop-up window as soon as i open a certain spreadsheet...
M MDubbelboer Jul 20, 2006 #2 open the workbook press "alt-f11" double click "this workbook", it's a Microsoft Excel Object Private Sub Workbook_Open() msgbox("whatever text you want") End Sub press alt-f11 to get back to your sheet
open the workbook press "alt-f11" double click "this workbook", it's a Microsoft Excel Object Private Sub Workbook_Open() msgbox("whatever text you want") End Sub press alt-f11 to get back to your sheet
