Hi Paula,

The best thing to do is follows Dave's advice, since Excel doesn't
provide any direct means of removing the Cancel button thorugh the
InputBox properties. It can be done using API calls, but the complexity
far outweighs the ease and versatility you can get by creating a
UserForm. However if you are really interested in the API method, let
me know.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=482077