Excel question

dannyd20

ok so I've created a spiffy excel file which is really neat and easy to use, cells are locked and protected so the user can only type where they are supposed to, etc.

I would like to add pop-up instructions so that when a user opens the file they get a quick message making sure they know what to do. Anyone know how to add a message which would pop up on opening the file ?

Thanks

calex71

not sure how to do what you are asking but if you right click on a cell you need the user to add data to and select add comment you can add instrustions on how that cell is to be filled in there, when you click on that cell , the comment will pop up telling the user what to do.

dannyd20

calex71 wrote:

not sure how to do what you are asking but if you right click on a cell you need the user to add data to and select add comment you can add instrustions on how that cell is to be filled in there, when you click on that cell , the comment will pop up telling the user what to do.

Thanks but that isn't really what I want to do. Just a simple pop up message box on opening the file is all I want. I'm sure it's possible.

alterneight

Try the following.
To access the Open event of a workbook:

1. Right click the small Excel icon next to File on the main toolbar.
2. Select Workbook from the left dropdown.
3. You should now see the following code:

Private Sub Workbook_Open()

End Sub

Change this to something like the following:

Private Sub Workbook_Open()
MsgBox "Please fill in the cells highlighted pink"
End Sub

Close out and save. You can change the text then afterwards to say whatever you want. It could also be worth bearing in mind that it could be useful to use Validation on cells so that users are restricted to entering numbers/text/days of year etc.

You can select this in Data>Validation so that if a wrong value is entered it will display an error message.

HTH

i71jskz5xu42pb

dannyd20 wrote:

Thanks but that isn't really what I want to do. Just a simple pop up message box on opening the file is all I want. I'm sure it's possible.

Tools/Macro/Visual Basic Editor

Define a sub routine for the Workbook on open event as follows

Private Sub Workbook_Open()
MsgBox ("This is not an alert")
End Sub

dannyd20

Thanks alterneight & PaschalNee - thats what I was looking for. I knew it was there somewhere!!