Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Minimize Ribbon in Excel 2007?
Thread ID: 269081 Message ID: 269103 # Views: 38 # Ratings: 2
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Friday, July 16, 2010 11:56:50 AM         
   


> >
> >
> > try this
> >
> > 
> > Local x as Excel.Application
> > x=CREATEOBJECT("excel.application")
> > x.Visible =.T.
> > 
> > 
> > 
> > x.ActiveWindow
> > 
> > x.Application.SendKeys ("^{F1}")
> > 
> > 

> >
> > Anil
> >
> > My Blog
>
>
> Fantastic! Thanks Anil.
>
> One more thing though, that will "toggle" visibility of ribbon. Is there any way we can check its status first so I can deactivate it conditionally?
>
>
>
> http://www.junblogs.com/
> http://weblogs.foxite.com/sandstorm36/default.aspx
> http://www.coderisland.com/forum/viewforum.php?f=10

yes but tricky

if x.Application.CommandBars.Item("Ribbon").Height > 100 Then

x.ActiveWindow

x.Application.SendKeys ("^{F1}")
endif


Anil

My Blog

ENTIRE THREAD

Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 10:52:12 AM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 11:39:13 AM
RE: Minimize Ribbon in Excel 2007? Posted by Mike Gagnon @ 7/16/2010 11:47:48 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:47:50 AM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 11:56:50 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:01:09 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 12:05:08 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:08:42 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:19:58 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 1:08:21 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 1:40:12 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 2:08:53 PM
RE: Minimize Ribbon in Excel 2007? Posted by Mike Gagnon @ 7/16/2010 11:44:01 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:51:08 AM
RE: Minimize Ribbon in Excel 2007? Posted by Borislav Borissov @ 7/16/2010 11:44:15 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:53:41 AM
RE: Minimize Ribbon in Excel 2007? Posted by Yousfi Benameur @ 7/16/2010 12:53:16 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 1:43:55 PM