dialogue pop up
 

Hi
i have entered the following after drawing up my message box:
Private Sub Workbook_Open()
MsgBox "Remember to print the MDA Approved page from the recos spreadhseet",
End Sub

but it doesnt pop up when i open the workbook. have i left something out?

thank you

dialogue pop up
 

Did you put it in the thisworkbook module? That is where it needs to be

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Micayla Bergen" wrote in message
...
Hi
i have entered the following after drawing up my message box:
Private Sub Workbook_Open()
MsgBox "Remember to print the MDA Approved page from the recos
spreadhseet",
End Sub

but it doesnt pop up when i open the workbook. have i left something out?

thank you

dialogue pop up
 

"Paul B" wrote:
Did you put it in the thisworkbook module? That is where it needs to be

Just adding on a little ..

Right-click on the Excel icon just to the left
of "File" on the menu Choose "View Code"
(This will bring you direct into the "ThisWorkbook" module)

Copy Paste the sub into the code window on the right
(clear the defaults there first)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

dialogue pop up
 

Hi Max,

Right-click on the Excel icon just to the left
of "File" on the menu

Just to add to your good advice, this is true if you have your spreadsheet
maximized, but if you don't, as often may be the case, the icon is at the
top-left of the spreadsheet, not by the "File" menu.

See:
http://tinyurl.com/ne83y


---
Regards,
Norman


"Max" wrote in message
...
"Paul B" wrote:
Did you put it in the thisworkbook module? That is where it needs to be

Just adding on a little ..

Right-click on the Excel icon just to the left
of "File" on the menu Choose "View Code"
(This will bring you direct into the "ThisWorkbook" module)

Copy Paste the sub into the code window on the right
(clear the defaults there first)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

dialogue pop up
 

Norman, thanks for elaboration !
(I'll have to trace the link you provided later, unable to do so right now ..)

Just found out that the comma at the end of the 2nd line in the sub posted
by the OP needs to be deleted as well, before the sub could be accepted in
VBE.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Norman Jones" wrote:
Hi Max,

Right-click on the Excel icon just to the left
of "File" on the menu

Just to add to your good advice, this is true if you have your spreadsheet
maximized, but if you don't, as often may be the case, the icon is at the
top-left of the spreadsheet, not by the "File" menu.

See:
http://tinyurl.com/ne83y


---
Regards,
Norman

dialogue pop up
 

"Norman Jones" wrote:
.. http://tinyurl.com/ne83y

Aha, I see Bob's at the other end of the line <g
Thanks, Norman.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---