msgbox buttons don't link. You can return a value

ans = msgbox("Desires",vbYesNo)
if ans = vbYes then
do something
else
do something else
End if

--
Regards,
Tom Ogilvy


"andy" wrote in message
...
I need help with a macro that needs to do the following things:

1. Look at workbook filename.
2. If it is equal to a certain filename, then bring up a message box.
3. Have one button link to the Save As.. function.
4. Have one button to just cancel, and enter the workbook.
5. If the workbook has a different name, then have it just open the
workbook
without the messagebox.

Any help would be greatly appreciated.