Macro's

Posted by Ampleford on November 09, 2001 5:40 AM

Can anyone tell me hoe to run a dialog box (or any macro) when a particular workbook is opened.....

Posted by Dank on November 09, 2001 5:45 AM

You need to use the Workbook_Open event. Try this:-

Open the VB editor, click View then Project Explorer. Double click the ThisWorkbook icon and then paste this code.

Private Sub Workbook_Open()
MsgBox "Clever eh?"
End Sub

That macro will now be run each time the workbook is open.

HTH,
Daniel.

Posted by Ampleford on November 09, 2001 6:20 AM

Thank You