First one:
Cancel = True

Second one:
Lookup this one in the help: Application.GetOpenFilename

RBS

"dok112" wrote in
message ...

1. How would I write this code? I need a workbook to not close using
the X in the top right corner. I want it to put up an error message
saying to use the Exit button. I know how to do the message box, but
when I try using the beforeclose call, I cant figure out how to write
code to stop the procedure once it's started. just a plain exit sub
doesnt work...

and

2. Is there a way, to have a textbox, that the user will click on a
button next to it, and it will open up a "explorer" box for them to
search for a file. Basically, I need something that will let them
select a file, and it's going to put the direct link (C:\windows\...)
in a textbox. Is this possible? I'm sure it is, I just don't know how
to do it.

Thanks everyone for your help...


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