![]() |
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. |
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. |
All times are GMT +1. The time now is 06:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com