hello VBA IS COOL
in excel, open the excel file
press alt-f11 (this brings up vb editor)
on the left side, should be a section with all sheets, etc assosiated with the excel file(Project - VBA Project)
choose the one called ThisWorkbook(dbl click)
see where it says (General)?click it and select Workbook
this will bring up in code
example:
Private Sub Workbook_Open()
' This is where you would put the code
End Sub
Any ways, u needed to show a message
where it says(' This is where you would put the code) in the example put this in
Msgbox "The message says hello", vbExclamation, "The Title"
so the following would be in the code
code:
'**************************************************
Private Sub Workbook_Open()
Msgbox "The message says hello", vbExclamation, "The Title"
End Sub
'****************************************************
Now
save the excel file and close it
now open it u should see a message pop up that says
"The message says hello" with a tilte "The Title" and an exclamation Mrk
Hope This helps if not post ur prob!!!
Stu Design