Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Menu which appears when you right mouse click in excel sheet Irish RN Excel Discussion (Misc queries) 1 July 8th 09 05:40 PM
how to get send option under file menu in excel sheet Send to Excel Discussion (Misc queries) 0 April 29th 08 07:20 PM
how to make find menu on excel work sheet? johans Excel Worksheet Functions 0 November 26th 07 08:31 AM
What replaces the Data/form menu item in Excel 2007? NJJorgy New Users to Excel 3 November 16th 07 10:44 PM
What is the keyboard shortcut 2 bring up the excel sheet tab menu? Rich K Excel Worksheet Functions 3 September 27th 06 10:14 PM


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"