Message pop-up when I'm opening an Excel workbook 1

[ferdo]

Hi,

My intention is to have first a message pop-up when I'm opening an Excel workbook which contains several macros (I want to tell to user which macro should be used first). How can I do this?

Thanks in advance.

Regards
Fernando

 

[francesca]

In VBE, under Workbook_Open, you want a Private Sub that will open a Form. You'll have to create your form and have code initiated by the radio button or check box that has been selected. It's not too hard, but it helps if you have a book. I learned VBE from a Visual Basic 6 For Dummies book. It was very helpful for this type of thing.

 

[ferdo]

Hi Francesca,

You are right, this can be a solution. I was thinking only at a simple pop-up message, without radio buttons or check box.

Regards
Fernando

 

[onlyadrafter]

Hello,

SOmething like this perhaps

Private Sub Workbook_Open()
MY_ENTRY = MsgBox("Hello and welcome.", vbOKOnly, "STARTING")
End Sub

this will need to go into the THIS WORKBOOK code window

----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!

 

[ferdo]

Hi,

Definitely you are the best user -...Thanks a lot. Its exactly what I was looking for.

Regards
Fernando