in Excel, how do I set up an alert popup when the file is opened?

[scgaca]

in Excel, how do I set up an alert popup when the file is opened?

[Norman Jones]

Hi Scgaca,

Try something like:

Sub Workbook_Open()

MsgBox Me.FullName & " now open!"

End Sub

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module:

Right click the Excel icon on the worksheet
(or the icon to the left of the File menu if you your workbook is
maximised)

View Code from the menu, and paste the code.

Alt-F11 to return to Excel.


---
Regards,
Norman



"scgaca" <scgaca@discussions.microsoft.com> wrote in message
news:362B0833-6985-4530-9EC0-61384B462455@microsoft.com...
> in Excel, how do I set up an alert popup when the file is opened?

[scgaca]

Perfect! That's exactly what we were looking for..Many thanks.

"Norman Jones" wrote:

> Hi Scgaca,
>
> Try something like:
>
> Sub Workbook_Open()
>
> MsgBox Me.FullName & " now open!"
>
> End Sub
>
> This is workbook event code and should be pasted into the workbook's
> ThisWorkbook module:
>
> Right click the Excel icon on the worksheet
> (or the icon to the left of the File menu if you your workbook is
> maximised)
>
> View Code from the menu, and paste the code.
>
> Alt-F11 to return to Excel.
>
>
> ---
> Regards,
> Norman
>
>
>
> "scgaca" <scgaca@discussions.microsoft.com> wrote in message
> news:362B0833-6985-4530-9EC0-61384B462455@microsoft.com...
> > in Excel, how do I set up an alert popup when the file is opened?
>
>
>