Assuming your are using VB6, not VBA:
As far as I remember you have some properties such as .Interactive etc which
control the user interface. You can also control how the .Parent (Excel) of
the displayed WB looks.
I found the OLE control somewhat flakey to work though.
You can easily float your own instance of Excel in your window and
manipulate that instead.
Let me know if you want to go that route.

NickHK

"amy's" <amy's @discussions.microsoft.com wrote in message
...
hi
i want to add excel sheet on my vb form.So i used oledb control . But when
i
clicked on excel sheet it adde a new menu on the top of the form that is
not
my requirement.i also want to control all the functionality of excel sheet
by
using programming.

Is it possible to add only excel sheet on my form with all functionality
but without any menu along with.