pop-up window in a spreadsheet????
pop-up window in a spreadsheet????
(OP)
HI all....
The forum is so active with muti disciplinary ppl....Gud stuff.
Here i need a favour...
I made a excel spreadsheet.I want, once the spreadsheet opens,a pop-up window should come which will be showing "NOTE......These are the following assumptions 1.......2......so on." The user must read this before he gets onto work with the spreadsheet. looks litbit dynamic activity,but.....
Do someone suggests me ,how can i succeed in this activity
The forum is so active with muti disciplinary ppl....Gud stuff.
Here i need a favour...
I made a excel spreadsheet.I want, once the spreadsheet opens,a pop-up window should come which will be showing "NOTE......These are the following assumptions 1.......2......so on." The user must read this before he gets onto work with the spreadsheet. looks litbit dynamic activity,but.....
Do someone suggests me ,how can i succeed in this activity





RE: pop-up window in a spreadsheet????
RE: pop-up window in a spreadsheet????
CODE
Const MSG As String = "NOTE......These are the following assumptions" _
& vbCrLf & "1......." _
& vbCrLf & "2......." _
& vbCrLf & "so on."
MsgBox MSG, vbInformation, "Assumptions"
End Sub
RE: pop-up window in a spreadsheet????
Tools / Macr / VBA editor
Double Click on "this workbook" in project explorer upper left to open the workbook code window.
On the code window top toward left, change "general" to "workbook"
On the code window toward the right, select open.
It will autogenerate
Private Sub Workbook_Open()
End Sub
Paste the above code in there (deleting redundant parts).
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: pop-up window in a spreadsheet????
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: pop-up window in a spreadsheet????
g8 job.....Thanks buddy...