Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
want to add excel sheet without menu on vb form
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
want to add excel sheet without menu on vb form
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Menu which appears when you right mouse click in excel sheet | Excel Discussion (Misc queries) | |||
how to get send option under file menu in excel sheet | Excel Discussion (Misc queries) | |||
how to make find menu on excel work sheet? | Excel Worksheet Functions | |||
What replaces the Data/form menu item in Excel 2007? | New Users to Excel | |||
What is the keyboard shortcut 2 bring up the excel sheet tab menu? | Excel Worksheet Functions |