dialogue pop up

M

Micayla Bergen

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
 
P

Paul B

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
 
M

Max

Paul B said:
Did you put it in the thisworkbook module? That is where it needs to be
Click to expand...

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)
 
N

Norman Jones

Hi Max,
Right-click on the Excel icon just to the left
of "File" on the menu >
Click to expand...

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
 
M

Max

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.
 
Top