Message box (97)

Topic

New Reply

Hi
Is it possible that when you open excel it will say

Reply | Quote

Replies

Hi Buckshot,
I think this may work.
Navigate to the Visual Basic Editor
Open the Project Explorer window
Select ThisWorkbook
Left hand drop down box select Workbook
Complete the procedure skeleton with the code in red

Private Sub Workbook_Open()
If Now() > 1200 Then MsgBox “Good Afternoon, Buckshot” _
Else MsgBox “Good Morning, Buckshot”
End Sub

Close the Visual Basic Editor.
Save your workbook under an appropriate name then close it.
Reopen your workbook and “Enable Macros”.
You will be greeted with a message as you required every time the workbook is opened.

Reply | Quote

Hi Buckshot,

Bandido has given a good epxlanation of how to create a macro that will be executed each time a particular workbook is opened. If you want to be greeted each time Excel is started, create this Workbook_Open macro in your personal macro workbook Personal.xls. See Legare Coleman’s Personal.xls Tutorial if you don’t know what Personal.xls is or how to use it.

Reply | Quote