Popup opening a spreadsheet
 

Hi all..
is anyway to force a popup to be shown as soon as a spreadsheet i
opened?
or, also better, any time I go from a worksheet to another in m
spreadsheet?

thanks in advance
*pima

--
pima
-----------------------------------------------------------------------
pimar's Profile: http://www.excelforum.com/member.php...nfo&userid=538
View this thread: http://www.excelforum.com/showthread.php?threadid=48238

Popup opening a spreadsheet
 

in VBA on the "This Workbook" tab, enter the following.

For On Open:

Private Sub Workbook_Open()
msgbox "your msg"
End Sub



For On Worksheet Change:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
msgbox "your msg"
End Sub


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=482386