Creating popup/prompt

[lkjing]

Hi does anyone know how to create popup/prompt when opening an excel file? Thanks!

 

[tmischler]

insert the following in the open_workbook event

msgbox "Hello"

 

[lkjing]

Thanks for the prompt reply! How do I go about doing it? Would you be able to list the steps?

 

[tmischler]

open your worksbook

click alt + F11 to open the VB Window

In the top left (Project window), double click "this workbook"

from the resulting dropdown boxes, select "workbook" and "open"

paste in the code

save

close

open again...

 

[lkjing]

Private Sub Workbook_Open(msgbox "Hello")

End Sub

is this the correct way to do it? I tried it but it did not work..

 

[lkjing]

anyone?

 

[pcc]

Private Sub Workbook_Open()
MsgBox "Hello"
End Sub

 

[lkjing]

Thanks...I did a successful run within the editor but the popup doesnt appear when I opened the file?

 

[texasalynn]

When you are in the visual editor, you have to put the code in "This Workbook"

texasalynn

 

[Harvey]

enable macros first