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?
