Msgbox on spreadsheet launch
 

Hi!

I want my message box to appear as soon as the excel sheet is opened, but
I'm drawing a blank as to how to do it. Help!

Msgbox on spreadsheet launch
 

Hi,

i the code for ThisWorkbook

Private Sub Workbook_Open()
MsgBox "my msg"
End Sub


J

"Abi" wrote:

Hi!

I want my message box to appear as soon as the excel sheet is opened, but
I'm drawing a blank as to how to do it. Help!

Msgbox on spreadsheet launch
 

See Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

You would want to use the workbook_open event.

--
Regards,
Tom Ogilvy


"Abi" wrote in message
...
Hi!

I want my message box to appear as soon as the excel sheet is opened, but
I'm drawing a blank as to how to do it. Help!

Msgbox on spreadsheet launch
 

thanks! The article helped greatly as I was missing a key step for the code.

"Tom Ogilvy" wrote:

See Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

You would want to use the workbook_open event.

--
Regards,
Tom Ogilvy


"Abi" wrote in message
...
Hi!

I want my message box to appear as soon as the excel sheet is opened, but
I'm drawing a blank as to how to do it. Help!