Start up Macro in spreadsheet


Posted by Bul_Bul on May 09, 2001 12:09 AM

Hiya, I have an excel file that I created and is used by a number of people. I would like a note to be displayed everytime the spreadsheet is open reminding users to put various items in certain places. I have reminded people but they conveniently 'forget' to do as asked. Is there anyway to set up a macro for this? Cheers and thanks for any help.

Posted by Dax on May 09, 2001 2:10 AM


If you go into the Visual Basic Editor by pressing Alt+F11 in your workbook. Make sure you can see the Project Explorer by clicking View, Project Explorer and double click on the ThisWorkbook icon. You will open a workbook code module. Something like this will display a message box every time the workbook is opened:-

Private Sub Workbook_Open()
MsgBox "Please put items in these places." & vbCrLf & _
"Fill cell A1, B2 and C3", vbInformation, "Reminder"
End Sub

HTH,
Dax.




Posted by Bul_Bul on May 09, 2001 4:24 AM

Your a championdogstar. Works BEAUTIFULLY. Don't suppose there is anyway to make this pop up intermittantly is there? Or perhaps a way that they can't disable the macro?